RE: Alert for hung database -- ie enq HW:
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "Joel.Patterson@xxxxxxxxxxx" <Joel.Patterson@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Nov 2012 16:59:55 +0100
For locking issues you can monitor the number of waiters and the wait duration.
v$wait_chains can also provide you with some useful information for monitoring
/ diagnosing.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Patterson, Joel
Sent: woensdag 21 november 2012 16:52
To: oracle-l@xxxxxxxxxxxxx
Subject: Alert for hung database -- ie enq HW:
11.2.0.3.3 on Solaris 10.
A database got stagnant due to a connection pooling issue, some parameters
where changed in the app, and the app started working again for a short time,
but only until the connections again began piling up behind the processes that
were left dormant in the first place -- so the app team stopped and started the
application, which of course left all the original oracle processes that were
messed up to begin with holding locks and whatever other resources, and were
not able to communicate back to the client. Restarting the database fixed all
that permanently.
DBOptimizer did identify an enq: HW on a particular table that is used all the
time, but otherwise was unable to go farther, (no info in tabs etc on any other
window).
So now the question has become, can we monitor for this and get an alerted?
If so, does anyone have any good ideas on it? We do have EM.
Thank you,
Joel
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
