Re: Control file expanding

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: teci_at_the-testas.net

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: ListGuru_at_fatcity.com (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).