Home » RDBMS Server » Server Administration » Controlfile expansion
Controlfile expansion [message #255445] Tue, 31 July 2007 23:14 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

I'm getting the following messages in alert.log file from last 4 days,

[B]kccrsz: expanded controlfile section 9 from 59671 to 60352 records
requested to grow by 602 record(s); added 3 block(s) of records[/B]


What message is this one? Do I've to do anything regarding this?

Thanks...
Re: Controlfile expansion [message #255459 is a reply to message #255445] Wed, 01 August 2007 00:07 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Nothing according to me.
Re: Controlfile expansion [message #255483 is a reply to message #255445] Wed, 01 August 2007 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It's just tell you that control file was extended.
It's an information message.

Regards
Michel
Re: Controlfile expansion [message #255522 is a reply to message #255445] Wed, 01 August 2007 02:07 Go to previous messageGo to next message
animesh303
Messages: 12
Registered: June 2006
Junior Member
Hi Gajini

This is just an informative message that new records are added to the "log_history" section of the control files and there are no entries that could be replaced. So the controlfile is automatically expanded.
This feature has come up from Oracle 8.

Regards
Animesh
Re: Controlfile expansion [message #255660 is a reply to message #255445] Wed, 01 August 2007 07:30 Go to previous messageGo to next message
gajini
Messages: 259
Registered: January 2006
Senior Member


Thanks...

May I know what causes the control file to expand suddenly in the last 3 days because from past 1 year,I didn't get any alert log message like this in the database...

Why it's happening?What causes it to expand?
Re: Controlfile expansion [message #255664 is a reply to message #255660] Wed, 01 August 2007 07:42 Go to previous messageGo to next message
animesh303
Messages: 12
Registered: June 2006
Junior Member
Hi gajini

The reasons could be many. As per Oracle it could be due to:

1. A new datafile is added beyond the maxdatafiles limited specified in the control file.
2. If new records are added to the "log_history" section of
the control files and there are no entries that could be replaced.

Note:
The automatic expansion only occurs up to the limit of the "init.ora" parameter "DB_FILES".

Regards
Animesh
Re: Controlfile expansion [message #255666 is a reply to message #255660] Wed, 01 August 2007 07:50 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,


Manage the Size of Control Files


The main determinants of the size of a control file are the values set for the MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES parameters in the CREATE DATABASE statement that created the associated database. Increasing the values of these parameters increases the size of a control file of the associated database.

http://download.oracle.com/docs/cd/B14117_01/server.101/b10739/control.htm#i1006155


regards
Taj
Previous Topic: ORA-01990
Next Topic: What is the Server Parameter File
Goto Forum:
  


Current Time: Fri Dec 09 13:55:20 CST 2016

Total time taken to generate the page: 0.13339 seconds