Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL insertion became slow, 10046 shows high waits on sqlnet break and reset

626479Feb 20 2009 — edited Feb 20 2009

oracle 9.2.0.8

insertion became slow for now reason ,

10046 trace and tkprof shows high sqlnet break reset wait , it suggests that sql might run into trouble

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net more data from client                9946        0.11          1.98
  SQL*Net message to client                   14651        0.00          0.00
  SQL*Net message from client                 14651        0.37         23.73
  SQL*Net break/reset to client               29260        0.52        109.68
  latch free                                     17        0.01          0.08
********************************************************************************



END OF STMT
EXEC #5:c=0,e=1266,p=0,cr=9,cu=16,mis=0,r=0,dep=0,og=4,tim=330857030897
ERROR #5:err=1 tim=33879759
WAIT #5: nam='SQL*Net break/reset to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #5: nam='SQL*Net break/reset to client' ela= 106487 p1=1413697536 p2=0 p3=0
WAIT #5: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
WAIT #5: nam='SQL*Net message from client' ela= 2786 p1=1413697536 p2=1 p3=0

we are wondering what is err=1 ?? equal to ORA-00001

and how to detect this problem

thanks

br/ricky

Edited by: zs_hzh on Feb 19, 2009 11:34 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 20 2009

Added on Feb 20 2009

#general-database-discussions

3 comments

519 views