select spid from v$process where addr in (select paddr from v$session where serial# in (select * from (select session_num from v$tempseg_usage order by blocks desc ) where rownum < 11)[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19015/viewspace-908209/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19015/viewspace-908209/