Home » RDBMS Server » Performance Tuning » LATCH FREE - HIGH DURING MID NIGHT
LATCH FREE - HIGH DURING MID NIGHT [message #209916] Mon, 18 December 2006 08:38 Go to next message
cresento
Messages: 2
Registered: April 2006
Location: Bangalore, India
Junior Member
Hi Team,

In our environment we are facing the heavy latch free events during the migh night. I want to know how to find out the reason for this latch free occurance.

Please let me know the procedures/sql queries that helps to find the culprits for it

Regards
Anoop
Wipro Technologies
Bangalore
988 650 4985

Report message to a moderator

Re: LATCH FREE - HIGH DURING MID NIGHT [message #209956 is a reply to message #209916] Mon, 18 December 2006 12:12 Go to previous message
dba_blr
Messages: 43
Registered: December 2006
Member
> Check v$session_wait for any "latch free..." event and inspect the P2 column for the latch#.

> Get the latch name from v$latchname.

Then you will get to know which latch contention is happening...

Report message to a moderator

Previous Topic: Post fast/complete refresh COMPILE_STATE=NEEDS_COMPILE
Next Topic: Performance tuning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 03:20:44 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.