Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

idea on message "kccrsz: expanded controlfile message..."

Status
Not open for further replies.
oracle8

oracle8

MIS
Sep 30, 2000
69
PH
hi!

Any ideas what this message means "kccrsz: expanded controlfile section 11 from 447 to 825 records requested to grow by 365 record(s); added 27 block(s) of records" i got this from our alert log. I'm using oracle 8.05 in win2003.

thanks,

Rommel
 
Sort by date Sort by votes
Hi,
This is not an error.
growth of your controlfile is usually due to a growth in your database. Your control file has grown to keep track of the new data size or logs used.

Section 11 is for "ARCHIVED LOG" and it is affected by control_file_record_keep_time as they to keep trace of log for the time speficied.

The maximum size of control file is 20000 database blocks on HP, Solaris, Windows, Linux and 10000 blocks on AIX.


HTH
Regards
Himanshu

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question
web app not saving "all" records suddenly
Replies
3
Views
981
carp
carp
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
890
Livia8
Livia8
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
570
Livia8
Livia8
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
778
Livia8
Livia8
kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
450
carp
carp

Part and Inventory Search

Sponsor

Back
Top