Databases Reference
In-Depth Information
3.
Query information about willing-to-wait latch requests:
COL NAME FOR A20
SELECT * FROM (
SELECT
NAME, GETS, MISSES, SLEEPS, SPIN_GETS, WAIT_TIME
FROM V$LATCH
ORDER BY GETS DESC
)
WHERE ROWNUM < 11;
4.
Query information about immediate latch requests:
COL NAME FOR A40
SELECT * FROM (
SELECT
NAME, IMMEDIATE_GETS, IMMEDIATE_MISSES
FROM V$LATCH
ORDER BY IMMEDIATE_GETS DESC
)
WHERE ROWNUM < 11;
How it works...
In step 2 we query the
V$SYSTEM_EVENT
dynamic performance view to see if latch
contention causes high waits on the system. Inspecting the value for the
TIME_WAITED
column, expressed in hundredths of a second, we obtain the following results:
