查看临时表空间使用情况

  select (sum (blocks))*8/1000 "MB",sql_id from v$sort_usage group by sql_id;

 

根据sql_id

select sql_text from v$sqltext where sql_id='xxxx'  group by piece;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8135069/viewspace-668104/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8135069/viewspace-668104/