Tracy,
We ran into some similar problems. Oracle will want
you to obtain several system state dumps when the
system is hung (we were still able to do this
connected internally through server manager). With my
limited expertise in reading state dumps the symptoms
appeared to be severe latch contention to the point
that the system appeared hung. Evidently there was
significant re-writes in this area from 8.0 to 8.1 and
there have been several attempts to resolve these
problems (some introducing new problems). If you can
issolate the latch from the state dumps, you can try
metalink again and specify the latch name. You may
have better luck finding a bug similar to the one you
are experiencing searching with the latch name and/or
specifying performance. There are several for
differing latches.
Of the ones in metalink, several were either closed as
not reproducable, or marked as fixed in one release or
another (although some of those were identical to
ours). In our situation, the problem did not occur
unless we were attempting to do an online consistent
export of our PeopleSoft financials database (the
method we use for copying the database, not for
backups). We got around the problem by kicking
everyone out of the database during exports. As we had
a viable work around and I did not want to deal with
oracle support, we simply did not pursue it with them.
Bill
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Tracy - Two ideas:
> On Metalink, get note 61552.1 Diagnosing Database
> Hanging Issues
> I would try to run STATSPACK (or utlbstat/utlestat)
> while the
> database is hanging. You can also run STATSPACK on a
> schedule.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Tuesday, April 30, 2002 2:22 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Pass
INET: wbpass_at_yahoo.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).
Received on Wed May 01 2002 - 08:33:21 CDT
