If you have such experience or insight to the issue, please kindly provide
your help.
*Platform*
DB: 8.1.6
OS: HP-UX 11.00
Hardware: PA-RISK, 8 cpu/16G memory
*Symptom*
- DB operation on *data dictionary* (such as create table) is hung.
All are hung at 'latch free' events. The latch name is 'dml lock
allocation'.
- # of DB processes will climbing up till maximum connections (150);
then the database is unavailable to all new connections
- Before # of DB processes overflow, some DB light operations on *user
table *are not affected, but not all*. *Huge operations (such as
backend job) on user tables are hung too because it might trigger *data
dictionary* operation.
*What actions have been taken, are being taken or need to be taken*
- Disabled large jobs such – in vain
- Restarted database – in vain. This helps little. After times
passes, the number of processes will climb up and database goes down again
eventually.
- Upper processes limit to 250 in database – GDBA is helping to make
the parameter change right now and the database will restart soon. But I
don't think this can resolve the issue. It only delays the outage.
- Logged TAR to metalink – 8.1.6 is out of support scope now. The
possibility to get support form Oracle Corp is low.
- *Further investigation needs to be taken upon the "data dictionary"
hung/latch free event. This is where we need your suggestion and help.
*
Thanks
Alex
--
--The mount is there.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 07 2007 - 10:12:16 CST