control file - cheeyoung/sqlplus-public GitHub Wiki
Wait Events
- control file sequential read
Errors
C.3.21 control file parallel write
C.3.22 control file sequential read
C.3.23 control file single write
ORA-00202: control file: 'string'
ORA-00227: corrupt block detected in control file: (block string, # blocks string)
2.54 CONTROL_FILE_RECORD_KEEP_TIME
| Property | Description |
|---|---|
| Default value | 7 (days) |
| Range of values | 0 to 365 (days) |
In the event a new record must be added to a reusable section and the oldest record has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections never expand, and records are reused as needed.
...
Note:This parameter applies only to records in the control file that are circularly reusable (such as archive log records and various backup records). It does not apply to records such as data file, tablespace, and redo thread records, which are never reused unless the corresponding object is dropped from the tablespace.