V$NONLOGGED_BLOCK

V$NONLOGGED_BLOCK displays ranges of nonlogged datafile blocks recorded in the control file.

Column	Datatype	Description
`FILE#`	`NUMBER`	Absolute file number of the data file that contains the nonlogged blocks
`BLOCK#`	`NUMBER`	Block number of the first nonlogged block in the range of nologged blocks
`BLOCKS`	`NUMBER`	Number of nonlogged blocks found starting with `BLOCK#`
`NONLOGGED_START_CHANGE#`	`NUMBER`	The smallest SCN on which any block in this block range became nonlogged. NULL if unknown.
`NONLOGGED_START_TIME`	`DATE`	The time that corresponds to `NONLOGGED_START_CHANGE#`. NULL if unknown.
`NONLOGGED_END_CHANGE#`	`NUMBER`	The largest SCN on which any block in this block range became nonlogged. NULL if unknown.
`NONLOGGED_END_TIME`	`DATE`	The time that corresponds to `NONLOGGED_END_CHANGE#`. NULL if unknown.
`RESETLOGS_CHANGE#`	`NUMBER`	The resetlogs SCN of the incarnation on which this block range was first marked as nonlogged. NULL if unknown.
`RESETLOGS_TIME`	`DATE`	The resetlogs time of the incarnation on which this block range was first marked as nologged. NULL if unknown.
`OBJECT#`	`VARCHAR2(40)`	The object ID this range belongs to. If this field is NULL, the object number is unknown.
`REASON`	`CHAR(7)`	The reason why this block range appears in this list. For Oracle Database 12c, it is always `UNKNOWN`.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data