SELECT s.sid sid, s.serial# serial, s.module module, s.program program, s.event, SUM(su.blocks) temp_blocks,
trunc(SUM(su.blocks) * 8096 / 1024 / 1024) temp_size , sql.sql_text
FROM v$sort_usage su, v$session s ,v$sql sql
WHERE su.session_addr = s.saddr and s.sql_id=sql.sql_id
GROUP BY s.sid, s.serial#, s.module, s.program , s.event, sql.sql_text
trunc(SUM(su.blocks) * 8096 / 1024 / 1024) temp_size , sql.sql_text
FROM v$sort_usage su, v$session s ,v$sql sql
WHERE su.session_addr = s.saddr and s.sql_id=sql.sql_id
GROUP BY s.sid, s.serial#, s.module, s.program , s.event, sql.sql_text
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24237320/viewspace-2143820/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24237320/viewspace-2143820/