DBA Data[Home] [Help]

SYS.DBMS_FEATURE_AWR dependencies on WRM$_SNAPSHOT

Line 84: from wrm$_snapshot

80: then
81: --> get snapshot count since last sample date
82: select count(*)
83: into feature_boolean_OUT
84: from wrm$_snapshot
85: where dbid = (select dbid from v$database)
86: and status = 0
87: and bitand(snap_flag, 1) = 1
88: and end_interval_time > DBFUS_LAST_SAMPLE_DATE;