I've seen this on AIX, the controlfile will expand depending on the parm maxloghistory that was set when the db was created.
eventually it will max out in size, and start spitting out errors in the alert log at every time a log switch happens. It happened to us about 3 weeks ago and i can't remember the max size. hth, joe Jamadagni, Rajendra wrote: > Yes, I just noticed it ... I have 6 logfiles at 200M and 2 of 128M ... > > It is all BasketBall games data and stats ... > > Date Day Total h0 h1 h2 h3 h4 h5 h6 > h7 h8 h9 h10 h11 h12 h13 h14 h15 h16 > h17 h18 h19 h20 h21 h22 h23 > 3/15/02 Fri 186 3 1 11 21 4 1 0 > 3 2 1 2 1 0 1 2 132 1 > 0 0 0 0 0 0 0 > 3/14/02 Thu 184 2 2 1 15 13 4 1 > 2 0 3 39 55 3 3 4 9 1 > 2 1 4 7 6 4 3 > > > The question is why would it be so crazy ... see between 3pm and 4 pm, we > had 132 log switches ... one thing I know we have huge data coming in ... > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > > -----Original Message----- > Sent: Friday, March 15, 2002 5:13 PM > To: Multiple recipients of list ORACLE-L > > > Too many archived logs? > > > Best Regards, > K Gopalakrishnan > Bangalore, INDIA > > > ------------------------------------------------------------------------ > > > *********************************************************************2 > > This e-mail message is confidential, intended only for the named recipient(s) above >and may contain information that is privileged, attorney work product or exempt from >disclosure under applicable law. If you have received this message in error, or are >not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 >and delete this e-mail message from your computer, Thank you. > > *********************************************************************2 > > > ESPN_Disclaimer.txt > > Content-Type: > > text/plain > Content-Encoding: > > 7bit > > -- Joe Testa, Oracle DBA Nothing new to put here, hmmmmmm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
