[Home] [Help] [Dependency Information]
Object Name: | GV_$NONLOGGED_BLOCK |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
FILE# | NUMBER | |||
BLOCK# | NUMBER | |||
BLOCKS | NUMBER | |||
NONLOGGED_START_CHANGE# | NUMBER | |||
NONLOGGED_START_TIME | DATE | |||
NONLOGGED_END_CHANGE# | NUMBER | |||
NONLOGGED_END_TIME | DATE | |||
RESETLOGS_CHANGE# | NUMBER | |||
RESETLOGS_TIME | DATE | |||
OBJECT# | VARCHAR2 | (40) | ||
REASON | CHAR | (7) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, FILE#
, BLOCK#
, BLOCKS
, NONLOGGED_START_CHANGE#
, NONLOGGED_START_TIME
, NONLOGGED_END_CHANGE#
, NONLOGGED_END_TIME
, RESETLOGS_CHANGE#
, RESETLOGS_TIME
, OBJECT#
, REASON
, CON_ID
FROM SYS.GV_$NONLOGGED_BLOCK;
|
|
|