трассировка бдTrace file /ORACLE_DEST/SRV/bdump/diag/rdbms/SRV/SRV/trace/SRV_ora_12165.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /home/ora/app/oracle/product/11.2.0.2
System name: Linux
Node name: ORCL.localnet
Release: 2.6.32-71.el6.x86_64
Version: #1 SMP Wed Sep 1 01:33:01 EDT 2010
Machine: x86_64
Instance name: SRV
Redo thread mounted by this instance: 1
Oracle process number: 41
Unix process pid: 12165, image:
oracle@ORCL.localnet
*** 2014-01-30 09:34:50.193
*** SESSION ID:(203.30889) 2014-01-30 09:34:50.193
*** CLIENT ID:() 2014-01-30 09:34:50.193
*** SERVICE NAME:(SYS$USERS) 2014-01-30 09:34:50.193
*** MODULE NAME:(JDBC Thin Client) 2014-01-30 09:34:50.193
*** ACTION NAME:() 2014-01-30 09:34:50.193
CLOSE #140559093168072:c=0,e=8,dep=0,type=1,tim=1391060090176669
=====================
PARSING IN CURSOR #140559093141480 len=50 dep=0 uid=220 oct=47 lid=220 tim=1391060090193513 hv=1159991935 ad='e5fd3ab0' sqlid='atrnd612k84mz'
begin dbms_utility.get_tz_transitions(:1,:2); end;
END OF STMT
PARSE #140559093141480:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1391060090193511
BINDS #140559093141480:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=171 siz=24 off=0
kxsbbbfp=7fd676d2eb28 bln=22 avl=03 flg=05
value=-1
Bind#1
oacdty=23 mxl=32767(32767) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=171 siz=32767 off=0
kxsbbbfp=7fd676d26728 bln=32767 avl=00 flg=05
EXEC #140559093141480:c=0,e=336,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1391060090193910
ERROR #1:err=6502 tim=1391060090193928
WAIT #140559093141480: nam='SQL*Net break/reset to client' ela= 9 driver id=1952673792 break?=1 p3=0 obj#=-1 tim=1391060090193975
WAIT #140559093141480: nam='SQL*Net break/reset to client' ela= 7780 driver id=1952673792 break?=0 p3=0 obj#=-1 tim=1391060090201770
WAIT #140559093141480: nam='SQL*Net message to client' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1391060090201792
WAIT #140559093141480: nam='SQL*Net message from client' ela= 3319 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1391060090205142
CLOSE #140559093141480:c=0,e=12,dep=0,type=1,tim=1391060090205179
=====================
PARSING IN CURSOR #140559093267640 len=175 dep=0 uid=220 oct=2 lid=220 tim=1391060090205529 hv=3621841296 ad='f5f13348' sqlid='4ccqvz3by1uch'
insert into SEARCH_SESSION (SEARCH_FILTER_DATA, SEARCH_FILTER_NAME, START_TIME, STATUS_CODE, STATUS_MESSAGE, STATUS_TIME, USER_NAME) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 )
END OF STMT
PARSE #140559093267640:c=0,e=313,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=1391060090205521
=====================
PARSING IN CURSOR #140559093214608 len=42 dep=1 uid=0 oct=3 lid=0 tim=1391060090206726 hv=844002283 ad='e82cbcd0' sqlid='ftj9uawt4wwzb'
select condition from cdef$ where rowid=:1
END OF STMT
PARSE #140559093214608:c=1000,e=616,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=1391060090206725
BINDS #140559093214608:
Bind#0
oacdty=11 mxl=16(16) mxlc=00 mal=00 scl=00 pre=00
oacflg=18 fl2=0001 frm=00 csi=00 siz=16 off=0
kxsbbbfp=7fd676d22950 bln=16 avl=16 flg=05
value=00004A08.006B.0001
EXEC #140559093214608:c=1000,e=10879,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,plh=1884964958,tim=1391060090217690
FETCH #140559093214608:c=0,e=57,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=1884964958,tim=1391060090217777
STAT #140559093214608 id=1 cnt=1 pid=0 pos=1 obj=31 op='TABLE ACCESS BY USER ROWID CDEF$ (cr=1 pr=0 pw=0 time=45 us cost=1 size=15 card=1)'
CLOSE #140559093214608:c=0,e=2943,dep=1,type=0,tim=1391060090220747
BINDS #140559093267640:
Bind#0
oacdty=01 mxl=32(01) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=171 siz=152 off=0
kxsbbbfp=7fd676d20568 bln=32 avl=00 flg=05
Bind#1
oacdty=12 mxl=07(49) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=171 siz=0 off=32
kxsbbbfp=7fd676d20588 bln=07 avl=07 flg=01
value="1/30/2014 0:0:0"
Bind#2
oacdty=01 mxl=32(01) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=171 siz=0 off=40
kxsbbbfp=7fd676d20590 bln=32 avl=00 flg=01
Bind#3
oacdty=01 mxl=32(01) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=171 siz=0 off=72
kxsbbbfp=7fd676d205b0 bln=32 avl=00 flg=01
Bind#4
oacdty=180 mxl=11(11) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=171 siz=0 off=104
kxsbbbfp=7fd676d205d0 bln=11 avl=00 flg=01
Bind#5
oacdty=01 mxl=32(08) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000010 frm=01 csi=171 siz=0 off=120
kxsbbbfp=7fd676d205e0 bln=32 avl=08 flg=01
value="TestUser"
Bind#6
oacdty=112 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=01 csi=171 siz=4000 off=0
kxsbbbfp=7fd676d2aaf8 bln=4000 avl=00 flg=05
EXEC #140559093267640:c=3000,e=18905,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=1391060090224478
ERROR #1:err=1858 tim=1391060090224504
STAT #140559093267640 id=1 cnt=0 pid=0 pos=1 obj=0 op='LOAD TABLE CONVENTIONAL (cr=0 pr=0 pw=0 time=10 us)'
WAIT #140559093267640: nam='SQL*Net break/reset to client' ela= 1 driver id=1952673792 break?=1 p3=0 obj#=-1 tim=1391060090224581
WAIT #140559093267640: nam='SQL*Net break/reset to client' ela= 1776 driver id=1952673792 break?=0 p3=0 obj#=-1 tim=1391060090226371
WAIT #140559093267640: nam='SQL*Net message to client' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1391060090226390
WAIT #140559093267640: nam='SQL*Net message from client' ela= 57688 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1391060090284098
XCTEND rlbk=1, rd_only=1, tim=1391060090284148
WAIT #0: nam='SQL*Net message to client' ela= 1 driver id=1952673792 #bytes=1 p3=0 obj#=-1 tim=1391060090284184
