Tag Archives: dba_hist_snapshot

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

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 , , , , , , | Leave a comment