http://www.cndba.cn/dave/article/1664

http://www.cndba.cn/dave/article/1664http://www.cndba.cn/dave/article/1664

http://www.cndba.cn/dave/article/1664http://www.cndba.cn/dave/article/1664http://www.cndba.cn/dave/article/1664http://www.cndba.cn/dave/article/1664

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;

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