SQL> 0select * from v$latchname 2 where name like sort% .
LATCH# NAME ---------- ----------------------------------------------- 138 sort extent pool
SQL> 0select addr,latch#,name,gets,misses,sleeps 2 from v$latch where latch#=138.
ADDR LATCH# NAME GETS MISSES SLEEPS -------- ---------- ------------------------------ ---------- ---------- ---------- 50011E00 138 sort extent pool 2297 0 0
|