User Tools

Site Tools


oracle:awr

This is an old revision of the document!


Table of Contents

AWR

retention

query

select
       extract( day from snap_interval) *24*60+
       extract( hour from snap_interval) *60+
       extract( minute from snap_interval ) "Snapshot Interval",
       extract( day from retention) *24*60+
       extract( hour from retention) *60+
       extract( minute from retention ) "Retention Interval"
from dba_hist_wr_control
/

modify

oracle/awr.1421946897.txt.gz · Last modified: 2015/01/22 17:14 by dodger