High Other Lock 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

Your instance has spent much of its In Oracle time waiting for a latch.

High Other Lock Wait findings

	Description
What to do next	Perform one of the following options: n   Examine Latching view overtime and the Oracle latches that are grouped in the Other Lock Wait. Then determine the dominant Oracle latch or enqueue and follow the tuning scenario set by this latch in the Statistics workspace. n   Examine high Other Lock Wait statements in the Activity workspace.
Advice	Examine the Oracle latches that are grouped into the Other Lock Wait. Determine the dominant Oracle latch or enqueue and follow the tuning scenario set by this event.

Get Oracle Certifications for all Exams
Free Online Exams.com