DBA Data[Home] [Help]

VIEW: SYS.V_$RESTORE_RANGE

Source

View Text - Preformatted

select db_id,
                 low_time,
                 high_time,
                 low_change#,
                 high_change#,
                 low_resetlogs_change#,
                 high_resetlogs_change#,
                 low_resetlogs_time,
                 high_resetlogs_time,
                 con_id
                 from TABLE(v_listRsRangePipe('V$ANY'))
View Text - HTML Formatted

SELECT DB_ID
, LOW_TIME
, HIGH_TIME
, LOW_CHANGE#
, HIGH_CHANGE#
, LOW_RESETLOGS_CHANGE#
, HIGH_RESETLOGS_CHANGE#
, LOW_RESETLOGS_TIME
, HIGH_RESETLOGS_TIME
, CON_ID
FROM TABLE(V_LISTRSRANGEPIPE('V$ANY'))