what is the process queue reference latch?

From: Tony van Lingen <tony.vanlingen_at_epa.qld.gov.au>
Date: Sat, 02 Dec 2006 10:33:08 +1000
Message-ID: <4570C9C4.7050701@epa.qld.gov.au>

Morning all,

Does any-one know what the process queue reference latch does? I've never seen it pop up in my monitors, but this morning in one database it has an appalling miss rate:

NAME                                                  WW        IMM

IMMEDIATE_GETS IMMEDIATE_MISSES

--------------------------------------------- ---------- ---------- 
-------------- ----------------
process queue reference                       .020905483 
187.158241        2390210          4473475

(from v$latch: ww - miss ratio of willing-to-wait type gets, imm - miss ratio of immediate gets, both in %)

This database is an Oracle 10.1.0.4 64bit on Solaris 9. Today only a handful of users are logged on and they are perfoming some sort of system test - they complain that the system is running like a dog and this is the only anomality I could find.

I found some hint on google that this has something to do with parallel execution., but I've checked for parallel execution, but can't find a trace of any. None has been defined as far as I know. Can Oracle decide to use parallellism anyway even if the degree on all tables is 1 and the parallel_* init vars are all default?

Cheers,

-- 
Tony van Lingen





___________________________

Disclaimer

This e-mail, including attachments if any, has originated from a Queensland government agency and may contain information that is confidential, or covered by legal professional privilege, and is intended for the named recipient(s) only.  If you have received this message in error, you are asked to inform the sender as quickly as possible and delete this message and any copies of this message from your computer system network.

Any form of disclosure, modification, distribution and/or publication of this e-mail, including attachments is prohibited.  Unless otherwise stated, this e-mail, including attachments represents the views of the sender and not the views of the Environmental Protection Agency.

Although this e-mail has been checked for the presence of computer viruses, the Environmental Protection Agency provides no warranty that all possible viruses have been detected and cleaned.  Any use of this e-mail could harm your computer system.


___________________________


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 01 2006 - 18:33:08 CST