Tuesday, June 14, 2011

Segment Hit Ratio Very Low Wait

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com


The hit ratio, for at least one of the objects related to the table, is very low.
Segment Hit Ratio Very Low findings

Description
What to do next
Perform the following options:
n   Examine associated statements in the Statements tab. Focus on the All access type in the Access Types table.
n   Examine buffer cache usage in the Statistics workspace. Check if there is an overall wait on the Free Buffer event.
Advice
If there are no outstanding contentions on the buffer cache consider moving the object into Keep or Recycle buffer cache pools.




  

Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: