RE: Latching / Oracle support problems

Hi Tom,

What makes you think that there is a problem here?

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
@
@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: Terrian, Thomas [mailto:Thomas.Terrian_at_standardregister.com] Sent: Thursday, 31 August 2000 23:09
To: Multiple recipients of list ORACLE-L Subject: Latching / Oracle support problems

AIX 4.3.2
Oracle 8.1.6
No OPS

Does anyone know what the following latches mean and more importantly how to fix them?

Latch                       Gets Misses %misses 
--------------------       ----- ------ ------- 
latch wait list              5754   368  6.39% 
parallel query alloc buffer 27083 10653 39.33% 
parallel query stats         1003   453 45.16% 
process queue                9979   113  1.13% 
process queue reference   4157244 61439  1.47% 
queryserver freelists       16348   522  3.19% 

Also for your enjoyment -- I log a TAR for this on Aug 18, 13 days ago. So far, no help from Oracle. I love it!!! - Gold support, production system, problem priority 2 -- and still no good answers from Oracle. Oh yea, baby.

Tom

Tom Terrian
Oracle DBA
(937) 221-1647 Received on Thu Aug 31 2000 - 07:50:49 CDT