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

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


Current Time: Sun Dec 04 12:42:14 CST 2016

Total time taken to generate the page: 0.08873 seconds