Why does INSERT have event "SQL*NET message from client"?
Hello,
Is it normal to have the wait event "SQL*NET message from client" when doing an insert? Note the INSERT, has a RETURNING INTO clause, if that is of any importance.
Here is the output from TKPROF for my insert statement :
Is it normal to have the wait event "SQL*NET message from client" when doing an insert? Note the INSERT, has a RETURNING INTO clause, if that is of any importance.
Here is the output from TKPROF for my insert statement :
SQL ID: bay0fjr24hv5t Plan Hash: 53785152 INSERT INTO mytable (id,col1,col2,...,col10) VALUES (seq.nextval,:1,:2,...,:10) RETURNING id INTO :id call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0
0