My main production DB in the past would get EXCURCIATINGLY slow during
normal business hours.
It would slow down so much that the customer service folks would revert to
"hand writing" orders on
paper. We could never identify any pattern or any culprit until I got the
book Oracle Performance
Tuning 101 (ISBN 0-07-213145-4) & got to attend a seminar presented by a
couple of the authors.
Based upon this new found knowledge & understanding of "Wait States" I was
able to write a
PL/SQL package which monitored the Wait States & sent me email when
specific thresholds
were exceeded. The code allowed me to identify the culprits with 100%
accuracy. One fix was
simply procedural. The other two problems involved POORLY written PL/SQL;
which just so
happened would get invoked only about once a month; but would wreak havoc
with other
sessions within this DB.
The code is available upon a direct request to me (and NOT back to this
list).
It is fairly well self-contained, but will require some customization to
work for you.
"John Shaw"
<John.Shaw@correctio To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
nscorp.com> cc:
Sent by: Subject: Re: corrupted database
[EMAIL PROTECTED]
12/20/2002 12:44 PM
Please respond to
ORACLE-L
If you ever find out the problem please post your findings - I'm going thru
a similar issue (9.2.0.2)
>>> [EMAIL PROTECTED] 12/20/02 01:50PM >>>
Lindon,
We have had a controller card go intermittently hay-wire and corrupted
the database. It even caused corruption to read-only tablespaces. It is
quite possible to corrupt Oracle read-only files with an os or hardware
problem. A good backup procedure was the saving grace for that one.
Currently I am attempting to diagnose slowdowns in logging into the
database. Normal connect time is < 3 seconds. During slow downs connect
> 60 seconds. All indication so far point to memory problems or
controller problems. Difficult to trouble shoot without tools built for
the os. (Novell). It takes a lot of paging through the os displays
before and after the trouble occurs. A reboot of the system clears the
trouble for a week or so.
Ron
>>> [EMAIL PROTECTED] 12/20/02 01:55PM >>>
Yes. Twice.
First time - bad controller. It wrote CRAP in random spots throughout
the
database. We had to recover after the hardware was replaced.
Second time - no idea. Oracle Support said they'd need mounds of info
from
the o/s and even then they may not be able to explain it. Since I
didn't
have the time to gather all the necessary info we let it go.
What a lovely thought for a Friday afternoon. At least my databases
aren't
corrupted.
Lisa Koivu
Oracle Datababy Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-----Original Message-----
Sent: Friday, December 20, 2002 1:35 PM
To: Multiple recipients of list ORACLE-L
connecti
The reason I ask is because people around me always blame Oracle when
things
stop working.
Anyways, the problem was traced to a corrupted Oracle database (as to
whether
the tables or the data file got corrupted. how and why - a $$$
consultant is
trying to find out).
How could an Oracle database get corruppted in the first place? Anyone
here
with
an experience of their Oracle database getting corrupted and what
caused it
and
what was done to fix it?
--
Lyndon Tiu
Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:
> Lyndon
> I would look at the wait statistics to see what is happening
inside
> Oracle. I would also look at the O.S. performance statistics to see
what
is
> happening underneath Oracle. Don't make any rash assumptions. Also,
are
any
> error messages or trace files generated?
> For me the funny story was a misunderstanding of the Unix "nice"
value
> for an unfamiliar platform. Long story short, we wound up with batch
> running
> at a higher priority than interactive users. New users were shut
out.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> Sent: Friday, December 20, 2002 9:45 AM
> To: Multiple recipients of list ORACLE-L
> connections
>
>
> Hello,
>
> Just in time for the Holidays. Oracle stops accepting connections.
>
> I am wondering if people here can give me their horror stories when
Oracle
> stops
> accepting new connections or stops accepting connections altogether?
> Scalability
> problems when you've got around 5,000 concurrent connections?
MTS/Shared
> server
> configurations enabled or disabled?
>
> It could be an Oracle problem or the application that's trying to
connect's
> fault.
>
> Any tips and insights into what caused your horror story and how it
was
> fixed.
> Thanks.
>
> Have a Happy Holidays everybody.
>
> --
> Lyndon Tiu
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Lyndon Tiu
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting
services
>
---------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting
services
>
---------------------------------------------------------------------
> 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).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon Tiu
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
