What is the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?

Rating:

The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter specifies the minimum number of days before a reusable record in the control file can be reused. In other words, it specifies the minimum age (in terms of days) of a record before the record can be reused. The default value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is seven. When a new record needs to be added to a reusable section, and the oldest record has not aged enough, the record section expands. If this parameter is set to zero, the reusable sections never expand, and records are reused as needed.

The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter applies only to those records (in the control file) that are circularly reusable (such as archived redo log records and various backup records). It does not apply to records such as data file records, tablespace records, and redo thread records, which are never reused unless the corresponding object is dropped from the tablespace.

Rating: