First page Back Continue Last page Graphics
…The Control File
Control file size will grow
- Affected by
- Control_file_record_keep_time parameter
- Frequency of log switches
- Frequency of backups
Notes:
The control file become larger as log switches, archiving and backups are performed. The records generated for log switches and archive logs can be overwritten – thus negating the need for the control file to expand – but not until the records are older than the value in the control_file_record_keep_time parameter. Thus, this parameter has a direct affect on the size of the control file.