DBA Data[Home] [Help]

VIEW: SYS.V_$NONLOGGED_BLOCK

Source

View Text - Preformatted

select "FILE#","BLOCK#","BLOCKS","NONLOGGED_START_CHANGE#","NONLOGGED_START_TIME","NONLOGGED_END_CHANGE#","NONLOGGED_END_TIME","RESETLOGS_CHANGE#","RESETLOGS_TIME","OBJECT#","REASON","CON_ID" from v$nonlogged_block
View Text - HTML Formatted

SELECT "FILE#"
, "BLOCK#"
, "BLOCKS"
, "NONLOGGED_START_CHANGE#"
, "NONLOGGED_START_TIME"
, "NONLOGGED_END_CHANGE#"
, "NONLOGGED_END_TIME"
, "RESETLOGS_CHANGE#"
, "RESETLOGS_TIME"
, "OBJECT#"
, "REASON"
, "CON_ID"
FROM V$NONLOGGED_BLOCK