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 re
"Jamadagni, Rajendra" wrote:
>
> I know it is normal, but is it normal to expand 15 times in 3 days?? This is
> 9012 in AIX 4.3
>
> If this isn't, where should I look for clues??
> TIA
> Raj
> __
> Rajendra Jamadagni MIS, ESPN Inc.
A Ha!
132 log switches ... just found the person responsible ... somehow was
testing a script to automatically clone the prod db, ON PROD MACHINE!! Well,
the log switches are back to normal numbers ... 3-5 an hour and although I
am not worried about control file expanding, I want to know why ...
Too many archived logs?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Rajendra
Sent: Friday, March 15, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L
I know it is normal, but is it normal to expand 15 times in 3 days?? This is
9012 in AIX 4.3
If this isn
Yes, I just noticed it ... I have 6 logfiles at 200M and 2 of 128M ...
It is all BasketBall games data and stats ...
DateDay Total h0 h1 h2 h3 h4 h5 h6
h7 h8 h9 h10 h11 h12 h13 h14 h15 h16
h17 h18 h19 h20
Not 1500 times, 15 individual times ... no we haven't changed any schema,
except maybe a change in a package or two. It is the March Madness season,
so we are getting a lot (I mean a lot) of data. It is all games data (after
all we are ESPN).
sorry for the confusion ...
Raj
__
Raj - Could you clarify please. Do you mean the control grew by 1,500% in 3
days? Or that you checked the size 15 times and it was larger each time?
Were you doing any database structure changes like adding
tablespaces, etc?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Ori