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)