I am actually having the same probs now there is a database which is is
getting froze for a few secs nobody can login but we did not know what time
this was occuring.
set a recording thro 9i for every sec later we came to know it was due to
cache buffer chain. almost 90 to 100 people were waiting on latch free wait
issue.
Found that all the users are running the same sql with the same data
requests.
Looks like we have to tune the sql.Yet to analyze the sqls.
-----Original Message-----
Sent: Wednesday, May 01, 2002 5:42 PM
To: Multiple recipients of list ORACLE-L
> As jared says keep querying the session_Wait u will defnetly bound to
catch
> the guy who might be causing the database to kneel down.
If the database is hung, the waits will likely show up immediately. I've
had
similar problems with waits on a latch that hung the database. If a
session
is hung, the waits should be there the first time you query.
It may also be that you can't even query the v$ views, in which case you
must resort to the state dumps.
Jared
Arun Chakrapani <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/30/2002 01:18 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Prod problem, please help!!!
If nothing works and when u know the database has frozen u can run the
following command
to take dump of the database so that u can send it to oracle for analyzing
or u can analyze it too.
As jared says keep querying the session_Wait u will defnetly bound to
catch
the guy who might be causing the database to kneel down.
Are u flushing shared pool quite frequently. check this out(this was one
of
the cause which was bringing the database down and was fixed in 7.2 or 7.3
i
INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arun Chakrapani
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).
