Database Tuning (MOSC)

MOSC Banner

Why does INSERT have event "SQL*NET message from client"?

edited Jun 19, 2012 3:49AM in Database Tuning (MOSC) 12 commentsAnswered ✓
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 :

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   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center