步骤:
1.select sid,event,p1,p1text from v$session_wait where event like 'SQL*Net more data from client%';
找到sid;
2.通过以下sql找到具体的sql脚本
SELECT sql_text
FROM v$sqltext a
WHERE a.hash_value = (SELECT sql_hash_value
FROM v$session b
WHERE b.SID = '&sid') ORDER BY piece ASC
3.分析你找到的sql,看看是不是做了全表扫描;
set autotrace trace explain
select count(*) from all_objects;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267897/viewspace-916260/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/267897/viewspace-916260/