Re: strange select issue

> kccrsz: denied expansion of controlfile section 9 by 1337 record(s)
> the number of records is already at maximum value (65535)
> krcpwnc: following controlfile record written over:
> RECID #500246 Recno 43823 Record timestamp
>
> being repeated lots in the alert log - has anyone seen this before and know
> how to fix it? i have seen the error on gogle but i can't seem to find the
> solution.

Section 9 in the control file is for keeping track of your archived redo logs. First, find out what your CONTROL_FILE_RECORD_KEEP_TIME parameter is set to. It may be the default of 7. Second, issue the following query:

SELECT * FROM v$controlfile_record_section WHERE type='LOG HISTORY';

What is the output from above?

You may have to rebuild the control file to fix this problem. You can try setting CONTROL_FILE_RECORD_KEEP_TIME to '0'.

You may also be hitting a bug which was fixed in Oracle 8.0.6. What version are you running?

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"