Home » RDBMS Server » Server Administration » alert log msg - very urgent
alert log msg - very urgent [message #216082] Wed, 24 January 2007 23:21 Go to next message
sajut
Messages: 69
Registered: January 2007
Member
Hi
Since today morning, I notice the following lines in alert.log. Is this a problem

kccrsz: expanded controlfile section 9 from 226 to 453 records
requested to grow by 2 record(s); added 1 block(s) of records

pls. help
Re: alert log msg - very urgent [message #216091 is a reply to message #216082] Thu, 25 January 2007 00:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Is this a problem
No. Not at all.
Re: alert log msg - very urgent [message #216093 is a reply to message #216082] Thu, 25 January 2007 00:09 Go to previous messageGo to next message
satheeshb
Messages: 5
Registered: July 2006
Junior Member
Hi,
Section 9 is related to log history. Control_file_record_keep_time define for how many days log_history should be retained. In your cause because of number of redo log switching is high, oracle not able find rewritable record in section 9 of controlfile. So it is expanding this controlfile to accomodate this new record.
This is espected behaviour.

Regards,
Satheesh Babu.S
Bangalore.
Re: alert log msg - very urgent [message #216097 is a reply to message #216082] Thu, 25 January 2007 00:25 Go to previous message
sajut
Messages: 69
Registered: January 2007
Member
Thanks, thank you very much
Previous Topic: Scheduled Jobs running twice
Next Topic: rollback segment header contention
Goto Forum:
  


Current Time: Fri Sep 20 13:49:32 CDT 2024