Re: Prod problem, please help!!!

Hi,

Please take system states dumps every 5 seconds withing 20-30 seconds. Let's read what's happening or not happening ?

Also,

You can upload your HANGANALYZE trace files to iOraHangAnalyzer. It's free.

regards...

Tracy Rahmlow wrote:

> I have opened a TAR with Oracle and am waiting a resolution. In the meantime,
> I am wondering if anybody else has any ideas while I wait.
>
> Specifics:
> IBM AIX 4.3
> Rdms 8.1.7.3
> Database ~75g
> OLTP database with approximately 500 dedicated connections and 500 shared connections with Oracle's MTS.
>
> Problem:
> The database hangs, and no user is able to connect to the instance, except locally through srvmgrl. Even within svrmgrl, we are unable to select anything from
> the
> database without the query hanging. However, we can abort the instance (shutdown abort) and start it up again just fine. This has happened on 4-22, 4-29 &
> 4-30 in the
> early afternoon. Usually, this is also our peak busy rate for the week. We are executing MTS for 4 applications, all other applications connect through
> dedicated server.
> The alert log contains a message unable to start a shared server process. This week it was #41 and last week it was #25. Normally, we do not exceed 5 shared
> servers. Another thing I noticed is that there is no time allocated to any of the newly created shared servers. It is as if, it can not process any work
> through existing shared
> servers and decides to allocate another one, until finally it freezes. I am not sure if this is a MTS problem because I would suspect that I should be able
> to establish
> a dedicated server connection. And I can not. I think that this is just a symptom of the underlying problem. It would appear to me that we are running out
> of a resource,
> however our sysadms do not see any resource problems. Does anybody have any ideas how to debug this? Thanks
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tracy Rahmlow
> INET: tracy.rahmlow_at_aexp.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).

--
Danisment Gazi Unal
http://www.ubTools.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal
  INET: dunal_at_ubTools.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).