Category Archives: AWR

Tablespace Usage History Report

Please make sure you are licensed to run sqls against DBA_HIST_*, like  dba_hist_tbspc_space_usage tblusage. The length of the report depends on  AWR retention. Please refer to  “Change AWR Retention & Interval” for how to change AWR retention. SQL> show parameter CONTROL_MANAGEMENT_PACK_ACCESS … Continue reading

Posted in AWR, SQL Scripts For DBA | Tagged , , , , , , , | Leave a comment

ORA-12751: cpu time or run time policy violation

There is an overnight auto-purge job failure every day by throwing “ORA-12751: cpu time or run time policy violation” error. Extracted trace file from slave process ( m001 ) of  Manageability Monitor Process ( MMON) : *** 2017-02-01 01:11:39.393 *** … Continue reading

Posted in AWR, Performance Tunning | Tagged , , , , , , , , | Leave a comment

Move AWR Snapshots From One Database to Another

A. Connect to source database as SYS, and extract AWR data. @$ORACLE_HOME/rdbms/admin/awrextr.sql …… ….. …. … Choose a Directory Name from the above list (case-sensitive). Enter value for directory_name: DATA_PUMP_DIR Using the dump directory: DATA_PUMP_DIR Specify the Name of the … Continue reading

Posted in AWR | Tagged , , , , , , , , , | Leave a comment

Change AWR Retention & Interval

A. Check current retention and interval. RETENTION = 8 days ( 11520 Mins ) ( Default ) INTERVAL = 1 hour ( 60 Mins ) ( Default ) SQL> desc dba_hist_wr_control Name Null? Type —————————————————– ——– ———————————— DBID NOT NULL NUMBER … Continue reading

Posted in AWR | Tagged , , , , , , | 1 Comment