oracle 临时段详解,关于临时段(temporary segment)的管理

SQL> select * from v$latchname

2  where name like 'sort%';

LATCH# NAME

---------- -----------------------------------------------

138 sort extent pool

SQL> select 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