OraFAQ Forum: Server Administration » Controlfile expansion

Home » RDBMS Server » Server Administration » Controlfile expansion

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Controlfile expansion [message #255445]

Tue, 31 July 2007 23:14

gajini
Messages: 262
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...

Report message to a moderator

Re: Controlfile expansion [message #255459 is a reply to message #255445]

Wed, 01 August 2007 00:07

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Nothing according to me.

Report message to a moderator

Re: Controlfile expansion [message #255483 is a reply to message #255445]

Wed, 01 August 2007 00:51

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Controlfile expansion [message #255522 is a reply to message #255445]

Wed, 01 August 2007 02:07

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

Report message to a moderator

Re: Controlfile expansion [message #255660 is a reply to message #255445]

Wed, 01 August 2007 07:30

gajini
Messages: 262
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?

Report message to a moderator

Re: Controlfile expansion [message #255664 is a reply to message #255660]

Wed, 01 August 2007 07:42

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

Report message to a moderator

Re: Controlfile expansion [message #255666 is a reply to message #255660]

Wed, 01 August 2007 07:50

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

Report message to a moderator

Previous Topic:	ORA-01990
Next Topic:	What is the Server Parameter File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:25:57 CDT 2024