Tuesday, June 14, 2011

Heavily Accessed Object 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


Much of the instance In Oracle time was spent on waits (lock, I/O, Buffer, and so on) for the object.
Heavily Accessed Object findings

Description
What to do next
Perform one of the following options:
n   To tune the object, go to the Tune Object workspace.
n   Examine the waits for the object in the Activity workspace.
Advice
To reduce the Waits for the object, follow the findings instructions in the Object workspace.
In the Object workspace, you can examine the following object data:
n   Access path pattern to the object (full scans, range scans, and so on)
n   Read-Write access patterns
n   Partition usage (such as whether there are extreme cases in use)
n   Object changes versus performance changes










Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: