1.99 DB_UNRECOVERABLE_SCN_TRACKING
DB_UNRECOVERABLE_SCN_TRACKING
enables or disables the tracking of unrecoverable (NOLOGGING
) direct-path INSERT and direct-path load operations.
Property | Description |
---|---|
Parameter type |
Boolean |
Default value |
|
Modifiable |
|
Modifiable in a PDB |
Yes |
Range of values |
|
Basic |
No |
Oracle RAC |
Multiple instances must have the same value |
When the value is set to true
, updates are made to the controlfile that maintains the V$DATAFILE
.UNRECOVERABLE_CHANGE#
and V$DATAFILE
.UNRECOVERABLE_TIME
columns. When the value is set to false
, updates are not made to the controlfile. Setting this parameter to false
may improve performance of direct-path NOLOGGING
operations.