1.具体SQL语句

select a.tablespace, b.sid, b.serial#, a.blocks,c.sql_text
  from v$sort_usage a,v$session b,v$sqltext c
 where a.session_addr = b.saddr
   and b.sql_address = c.address
 order by a.tablespace,b.sid,b.serial#,c.address, c.piece;

2.执行结果

TABLESPACE                            SID    SERIAL#     BLOCKS SQL_TEXT
------------------------------ ---------- ---------- ---------- ----------------------------------------------------------------
TEMP                                  267      26882        128 select a.tablespace, b.sid, b.serial#, a.blocks,c.sql_text   fro
TEMP                                  267      26882        128 select a.tablespace, b.sid, b.serial#, a.blocks,c.sql_text   fro
TEMP                                  267      26882        128 m v$sort_usage a,v$session b,v$sqltext c  where a.session_addr =
TEMP                                  267      26882        128 m v$sort_usage a,v$session b,v$sqltext c  where a.session_addr =
TEMP                                  267      26882        128  b.saddr    and b.sql_address = c.address  order by a.tablespace
TEMP                                  267      26882        128  b.saddr    and b.sql_address = c.address  order by a.tablespace
TEMP                                  267      26882        128 ,b.sid,b.serial#,c.address, c.piece
TEMP                                  267      26882        128 ,b.sid,b.serial#,c.address, c.piece

8 rows selected.

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle