SQL*Net message from client waiting
This is run from our application as it connects.
Why would the this take up so much rousources?
I cannot figure it out.
PHP Code:
select count(*)
from
dual
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 11018 0.56 0.65 0 0 0 0
Execute 11018 2.88 2.81 0 0 0 0
Fetch 11018 2.31 2.14 6 33055 0 11018
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 33054 5.75 5.62 6 33055 0 11018
Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 47
Rows Row Source Operation
------- ---------------------------------------------------
1 SORT AGGREGATE (cr=3 r=0 w=0 time=100 us)
1 TABLE ACCESS FULL DUAL (cr=3 r=0 w=0 time=89 us)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 28819 0.00 0.06
SQL*Net message from client 28819 2.02 27.39
latch free 4 0.00 0.00
db file sequential read 3 0.00 0.00
SQL*Net more data from client 2 0.09 0.18
********************************************************************************