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
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

Wipro Technologies
988 650 4985
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
Messages: 43
Registered: December 2006
> 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...

Previous Topic: Post fast/complete refresh COMPILE_STATE=NEEDS_COMPILE
Next Topic: Help - Performance Issue - statspack report attached
Goto Forum:

Current Time: Wed Aug 23 01:20:51 CDT 2017

Total time taken to generate the page: 0.03165 seconds