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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: what is the process queue reference latch?

Re: what is the process queue reference latch?

From: Tony van Lingen <tony.vanlingen_at_epa.qld.gov.au>
Date: Mon, 04 Dec 2006 09:59:02 +1000
Message-ID: <457364C6.5030006@epa.qld.gov.au>


Yes, except that this is version 10.1.0.4 and that bug was fixed in 10.1.0.3. The logs don't show that ora-600 error that precedes the looping of PMON either..

Also, misses is almost twice as high as gets. I always thought that the misses were a sub-set of the gets, which should set a max to the amount of misses one could possibly get (misses <= gets). Is that correct?

Cheers,
Tony

Alberto Dell'Era wrote:

>> 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.
>
>
> Maybe bug/note 3415971.8 may help; a lot of misses on
> "process queue reference" are a very likely side-effect of that bug,
> if I interpret correctly the description (I'm not a Support Specialist
> nor a kernel developer ;)
>



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 Sun Dec 03 2006 - 17:59:02 CST

Original text of this message

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