|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
SQL> create table tv (t1 int unique);
Table created.
SQL> insert into tv values(1);
1 row created.SQL> commit;
Commit complete.
SQL> oradebug setmypid;Statement processed.SQL> oradebug event 10046 trace name context forever,level 8;
Statement processed.SQL> insert into tv values(1);
insert into tv values(1)
*ERROR at line 1:
ORA-00001: unique constraint (SYS.SYS_C009343) violated
SQL> oradebug event 10046 trace name context off;
Statement processed.SQL> select event, total_waits from v$session_event where event like '%break%' and sid =(select distinct sid from v$mystat);
EVENT TOTAL_WAITS---------------------------------------------------------------- -----------SQL*Net break/reset to client 2
|
|
1
2
3
4
5
6
|
EXEC #2:c=8000,e=9020,p=0,cr=10,cu=9,mis=0,r=0,dep=0,og=1,plh=0,tim=1279117896316991
ERROR #2:err=1 tim=1279117896317039STAT #2 id=1 cnt=0 pid=0 pos=1 obj=0 op='LOAD TABLE CONVENTIONAL (cr=0 pr=0 pw=0 time=0 us)'
WAIT #2: nam='SQL*Net break/reset to client' ela= 33 driver id=1413697536 break?=1 p3=0 obj#=-1 tim=1279117896317323
WAIT #2: nam='SQL*Net break/reset to client' ela= 521 driver id=1413697536 break?=0 p3=0 obj#=-1 tim=1279117896317915
WAIT #2: nam='SQL*Net message to client' ela= 5 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=1279117896317964
|
2次SQL*Net break/reset to client分别为33us和521us; 设计不良的应用程序或者程序中存在较多未安置的exception都可能导致SQL*Net break/reset to client等待事件。
本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1277491