OraFAQ Forum: Performance Tuning » Latch waits are 39% of non-idle wait time

Home » RDBMS Server » Performance Tuning » Latch waits are 39% of non-idle wait time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Latch waits are 39% of non-idle wait time [message #65898]

Tue, 25 January 2005 10:32

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

Report message to a moderator

Re: Latch waits are 39% of non-idle wait time [message #65904 is a reply to message #65898]

Wed, 26 January 2005 09:43

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.

Report message to a moderator

Previous Topic:	Perfomance difference
Next Topic:	DML suddenly taking a long time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 19 09:30:23 CST 2026