Database Reference
In-Depth Information
SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 12';
Session altered.
SQL> VARIABLE id NUMBER
SQL> INSERT INTO customer(id, name, phone)
VALUES (customer_id_seq.nextval, '&name', '&phone')
RETURNING id INTO :id;
Enter value for name: Deevers
Enter value for phone: +1 310 45678923
1 row created.
Excerpts of the resulting SQL trace file are reproduced here:
*** ACTION NAME:() 2007-11-28 22:02:15.625
*** MODULE NAME:(SQL*Plus) 2007-11-28 22:02:15.625
*** SERVICE NAME:(SYS$USERS) 2007-11-28 22:02:15.625
*** SESSION ID:(32.171) 2007-11-28 22:02:15.625
WAIT #6: nam='SQL*Net message to client' ela= 6 driver id=1111838976 #bytes=1 p3=0
obj#=15919 tim=230939271782
*** 2007-11-30 09:45:33.828
WAIT #6: nam='SQL*Net message from client' ela= 235333094 driver id=1111838976
#bytes=1 p3=0 obj#=15919 tim=231174604922
=====================
PARSING IN CURSOR #4 len=122 dep=0 uid=32 oct=2 lid=32 tim=231174605324 hv=798092392
ad='6b59f600' sqlid='96032xwrt3v38'
INSERT INTO customer(id, name, phone)
VALUES (customer_id_seq.nextval, 'Deevers', '+1 310 45678923')
RETURNING id INTO :id
END OF STMT
PARSE #4:c=0,e=111,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=231174605317
BINDS #4:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=03 fl2=1000000 frm=00 csi=00 siz=24 off=0
kxsbbbfp=07a7e7a0 bln=22 avl=04 flg=05
value=370011
WAIT #4: nam='SQL*Net message to client' ela= 7 driver id=1111838976
#bytes=1 p3=0 obj#=15919 tim=231174606084
EXEC #4:c=15625,e=673,p=0,cr=0,cu=3,mis=0,r=1,dep=0,og=1,tim=231174606139
STAT #4 id=1 cnt=0 pid=0 pos=1 obj=0
op='LOAD TABLE CONVENTIONAL (cr=0 pr=0 pw=0 time=0 us)'
STAT #4 id=2 cnt=1 pid=1 pos=1 obj=15920
op='SEQUENCE CUSTOMER_ID_SEQ (cr=0 pr=0 pw=0 time=0 us)'
*** 2007-11-30 09:45:39.015
WAIT #4: nam='SQL*Net message from client' ela= 5179787 driver id=1111838976
#bytes=1 p3=0 obj#=15919 tim=231179786085
For details on how to interpret extended SQL trace files and how to automatically generate
a resource profile for performance diagnosis, please refer to Part 8.
Search WWH ::




Custom Search