Control File section - kccrsz
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Control File section - kccrsz

  1. #1
    Join Date
    Aug 2002
    Posts
    43
    Does anyone know what this means.

    kccrsz: expanded controlfile section 11 from 937 to 951 records
    requested to grow by 9 record(s); added 1 block(s) of records

    Any suggestions will be appreciated.

    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    look V$CONTROLFILE_RECORD_SECTION for 951, it's probably something about archived logs

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    It means that Oracle had to add some records to your controlfile (you could also noticed that your controlfile grew in size when that happened). Some sections of controlfile are reusable in circular fashion, yet the parameter CONTROLFILE_RECORDS_KEEP_TIME controls how long records in those reusable sections must be kept in there before they can be reused. The defoult for this parameter is 7 (days).

    In your case section 11 refers to ARCHIVED LOG section. It had to add some new records, because all records archived logs in the controlfile were younger than your CONTROLFILE_RECORDS_KEEP_TIME. You can check all the reusable sections of the controlfile by looking at V$CONTROLFILE_RECORD_SECTION.

    It is nothing to be worried about that message, except maybe you should check your CONTROLFILE_RECORDS_KEEP_TIME setting.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Aug 2002
    Posts
    43
    Thanks Pando and Jurij for your prompt reply. Ever so grateful for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width