DBA Data[Home] [Help]

SYS.DBMS_FEATURE_AWR dependencies on DBA_HIST_SNAPSHOT

Line 26: dba_hist_snapshot SN

22: ,MAX(SN.snap_id) as MAX_snap
23: ,MIN(CAST(begin_interval_time AS DATE)) as MIN_date
24: ,MAX(CAST(end_interval_time AS DATE)) as MAX_date
25: from
26: dba_hist_snapshot SN
27: ,wrh$_stat_name ST
28: where
29: SN.begin_interval_time > TRUNC(SYSDATE) - 7
30: and SN.end_interval_time < TRUNC(SYSDATE)