SQL_Net more data from client.docVIP

SQL_Net more data from client SQL*Net message from client 如果程序通过游标取数，但是程序处理数据的速度远远落后于取数的速度的话，监控用户进程会发现其长时间的INACTIVE，一直等待程序再次取数，并在SQL*Net message from client上等待 下面是一个例子，通过游标一次取3W条数据，然后SLEEP 60秒以模拟对数据的处理 为了模拟用户程序连接，使用了一个DBLINK连接到本数据库。这样可以避免看到的是进程在PL/SQL lock timer上等待 declare type demo_array_type is varray(3001) of big_table%rowtype; demo_array demo_array_type; cursor c1 is select /*+parallel(a,8)*/* from big_table@myself a; rows int:=3000; begin open c1; loop fetch c1 bulk collect into demo_array limit rows; dbms_output.put_line(c1%rowcount); exit when c1%notfound; dbms_lock.sleep(60); end loop; close c1; end; / 然后看看SQL运行情况 SQL select decode(a.QCSERIAL#, null, PARENT, CHILD) stmt_level, 2 a.SID, 3 a.SERIAL#, 4 b.USERNAME, 5 b.OSUSER, 6 b.SQL_HASH_VALUE, 7 b.SQL_ADDRESS, 8 a.DEGREE, 9 a.REQ_DEGREE 10 from v$px_session a, v$session b 11 where a.SID = b.SID 12 order by a.QCSID, stmt_level desc; STMT_LEVEL SID SERIAL# USERNAME OSUSER SQL_HASH_VALUE SQL_ADDRESS DEGREE REQ_DEGREE ---------- ---------- ---------- ------------------------------ ------------------------------ -------------- ----------- ---------- ---------- PARENT 142 43 CTAIS2 zhangqiaoc 2230467307 28176C40 CHILD 140 7 CTAIS2 zhangqiaoc 2230467307 28176C40 7 8 CHILD 137 10 CTAIS2 zhangqiaoc 2230467307 28176C40 7 8 CHILD 146 13 CTAIS2 zhangqiaoc 2230467307 28176C40 7 8 CHILD 141 11 CTAIS2 zhangqiaoc 2230467307 2