V$LATCH

SQL> set linesize 80SQL> desc v$latch Name   Null?    Type ----------------------------------------- -------- ---------------------------- ADDR    RAW(8) LATCH#     NUMBER LEVEL#     NUMBER NAME    VARCHAR2(64) HASH    NUMBER GETS    NUMBER    ---成功的以willing-to-wait获取latch次数 MISSES     NUMBER   ---以willing-to-wait请求latch,等待次数 SLEEPS     NUMBER IMMEDIATE_GETS     NUMBER IMMEDIATE_MISSES    NUMBER   ---以immediate模式请求latch不成功次数 WAITERS_WOKEN    NUMBER WAITS_HOLDING_LATCH    NUMBER SPIN_GETS    NUMBER  ---以willing-to-wait获取latch,自旋的次数 SLEEP1     NUMBER SLEEP2     NUMBER SLEEP3     NUMBER SLEEP4     NUMBER SLEEP5     NUMBER SLEEP6     NUMBER SLEEP7     NUMBER SLEEP8     NUMBER SLEEP9     NUMBER SLEEP10    NUMBER SLEEP11    NUMBER WAIT_TIME    NUMBER ----等待一共花费的时间 微妙SQL> 

看下环境的

000000006001EEC8190 object queue header heap      132226143       2436000000006002F268280 In memory undo latch      205204679       9761000000006000D430 29 enqueue hash chains       267514291      120850000000060030720287 corrupted undo seg latch      285521418      40062000000006001CD48175 active checkpoint queue latch      294168848    2673287000000006000A358 14 session idle bit      344563821       11900000000060023FF0207 redo writing      344982512    2827682000000006003C1B0336 shared pool       364387694      66301000000006001D6C0178 cache buffer handles      392251478 51000000006001EA98185 simulator lru latch       402277057     359563000000006002E108274 undo global data      532455991    1910195000000006001B828172 cache buffers lru chain      611721976    1241193000000006000D198 27 messages      691980109    7842612000000006001D768179 multiblock read objects      887374532   174212100000000060035480309 row cache objects     2115025379     768071000000006001E880184 cache table scan latch     3950881130    7694488000000006001CDE8176 checkpoint queue latch     1.0420E+10     442924000000006001EE20189 object queue header operation     2.7537E+10    3646966000000006001EB38186 simulator hash latch     7.4623E+10    1213481000000006001D618177 cache buffers chains     9.1272E+11  144779709582 rows selected.SQL> l  1* select addr,latch#,name,gets,spin_gets from v$latch order by getsSQL>