RE: Prod problem, please help!!!

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 <ArunC_at_1800FLOWERS.com>
Sent by: root_at_fatcity.com
04/30/2002 01:18 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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: ArunC_at_1800FLOWERS.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arun Chakrapani
  INET: ArunC_at_1800FLOWERS.com

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).