select sess.username, sql.sql_text, sort1.blocks
from v$session sess, v$sqlarea sql, v$sort_usage sort1
where sess.serial# = sort1.session_num and sort1.sqladdr = sql.address and sort1.sqlhash = sql.hash_value and sort1.blocks > 200;
http://www.cndba.cn/dave/article/1774
http://www.cndba.cn/dave/article/1774
http://www.cndba.cn/dave/article/1774
http://www.cndba.cn/dave/article/1774
http://www.cndba.cn/dave/article/1774
http://www.cndba.cn/dave/article/1774
http://www.cndba.cn/dave/article/1774
http://www.cndba.cn/dave/article/1774
http://www.cndba.cn/dave/article/1774
http://www.cndba.cn/dave/article/1774
版权声明：本文为博主原创文章，未经博主允许不得转载。
CNDBA社区
