select snap_id, dbid, instance_number, startup_time,
begin_interval_time, end_interval_time,
flush_elapsed, snap_level, error_count, snap_flag, snap_timezone,
con_dbid_to_id(dbid) con_id
from WRM$_SNAPSHOT
where status = 0
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, STARTUP_TIME
,
BEGIN_INTERVAL_TIME
, END_INTERVAL_TIME
,
FLUSH_ELAPSED
, SNAP_LEVEL
, ERROR_COUNT
, SNAP_FLAG
, SNAP_TIMEZONE
,
CON_DBID_TO_ID(DBID) CON_ID
FROM WRM$_SNAPSHOT
WHERE STATUS = 0
|
|
|