Месяц: Июль 2015

audit purge

от

short way truncate table sys.aud$ =))) create purge audit job Or audit all purge job: create job to update what can job delete from audit SELECT * FROM dba_audit_mgmt_config_params; SELECT * FROM dba_audit_mgmt_last_arch_ts; select * from DBA_AUDIT_MGMT_CLEAN_EVENTS; Standard_Audit_Trail_Purge_Job STOP: Drop: Manual run: list of DBMS_AUDIT_MGMT. —>AUDIT_TRAIL_ALL

awr report by hour

от

simplest way to generate awr report by hour after benchmark
export awr

@?/rdbms/admin/awrextr.sql

import awr

@?/rdbms/admin/awrload.sql

— make sure to set line size appropriately
— set linesize 152

generate awr

 set termout off
set linesize 80
set pagesize 10000
select 'spool awrrpt_dwhfrn_'|| snap_id ||'.html'|| chr(13)||
 'select output from table(dbms_workload_repository.awr_report_text('||dbid||',1,'||snap_id||','|| LEAD (snap_id, 1)  OVER (ORDER BY  dbid,snap_id ) ||',0));' || chr(13)||
 ' spool off '
 from dba_hist_snapshot where dbid !=1399642255 and extract( minute from begin_interval_time ) <2 ;