Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> oracle database performance/availability/outage issue

oracle database performance/availability/outage issue

From: Alex zeng <junk4trash_at_gmail.com>
Date: Thu, 8 Feb 2007 00:12:16 +0800
Message-ID: <3df370bd0702070812m6b160a20if36c5d34e2c6f767@mail.gmail.com>


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*

  1. 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'.
  2. # of DB processes will climbing up till maximum connections (150); then the database is unavailable to all new connections
  3. 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*

  1. Disabled large jobs such in vain
  2. Restarted database in vain. This helps little. After times passes, the number of processes will climb up and database goes down again eventually.
  3. 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.
  4. Logged TAR to metalink 8.1.6 is out of support scope now. The possibility to get support form Oracle Corp is low.
  5. *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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US