SQL*Net more data from client

步驟：
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;

[@more@]