Search This Blog

Tuesday, October 2, 2007

"kccrsz: expanded controlfile section"


kccrsz: expanded controlfile section 11 from 224 to 252 records
requested to grow by 2 record(s); added 1 block(s) of records
Controlfile has resized from 190 to 192 blocks.

If we found above message in alert_sid.log file then no need to warry about it.
it is just information message for controlfile is increase in size.


we can check "v$controlfile_record_section" view or "controlfile_record_keep_time" parameters

Eg:
kccrsz: expanded controlfile section 11 from 224 to 252 records
Note: Section 11 is belong to log_history.


When controlfile possibly extended

1. Any upgrade or migration on database
2. Any Phyiscal changes in database

No comments: