Personal tools
You are here: Home → Oracle → How To's → How to Check FREELIST contention in Buffer Cache
Navigation
Log in


Forgot your password?
 
Document Actions

How to Check FREELIST contention in Buffer Cache

How to Check FREELIST contention in Buffer Cache


SELECT s.segment_name, s.segment_type, s.FREELISTs, w.wait_time, w.seconds_in_wait, w.state FROM dba_segments s, v$session_wait w WHERE w.event='buffer busy waits' AND w.p1=s.header_file AND w.p2=s.header_block
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls