Home » RDBMS Server » Performance Tuning » Latch waits are 39% of non-idle wait time
Latch waits are 39% of non-idle wait time [message #65898] Tue, 25 January 2005 10:32 Go to next message
lily
Messages: 44
Registered: September 2000
Member
I get the following message frequently:
--Latch waits are 20%/39% of non-idle wait time--

How can I manage Spin count and latch sleeps in Oracle 9.2.0.5? Any other suggestion/documentation on how to tune Latches?

Pl help,

regards,
Lily
Re: Latch waits are 39% of non-idle wait time [message #65904 is a reply to message #65898] Wed, 26 January 2005 09:43 Go to previous message
KAIn
Messages: 1
Registered: January 2005
Junior Member
When you ask such a question and don't know the answer,
then actually you DON'T need to.
BTW, there are lot of latch types in modern Oracle
releases.
Previous Topic: Perfomance difference
Next Topic: DML suddenly taking a long time
Goto Forum:
  


Current Time: Wed Sep 23 15:13:18 CDT 2020