Database Reference
In-Depth Information
17 INSERT INTO customer(name, phone) VALUES (:name, :phone)
18 RETURNING id INTO :id
19 END OF STMT
20 PARSE #1:c=0,e=84,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=789991639091
21 =====================
22 PARSING IN CURSOR #2 len=40 dep=1 uid=61 oct=3 lid=61 tim=789991640250
hv=1168215557 ad='6cbaf25c'
23 SELECT CUSTOMER_ID_SEQ.NEXTVAL FROM DUAL
24 END OF STMT
25 PARSE #2:c=0,e=72,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=789991640243
26 EXEC #2:c=0,e=62,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,tim=789991641167
27 =====================
28 PARSING IN CURSOR #3 len=129 dep=2 uid=0 oct=6 lid=0 tim=789991641501
hv=2635489469 ad='6bdb9be8'
29 update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,
cache=:7,highwater=:8,audit$ =:9,flags=:10 where obj#=:1
30 END OF STMT
31 PARSE #3:c=0,e=68,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=789991641494
32 EXEC #3:c=0,e=241,p=0,cr=1,cu=2,mis=0,r=1,dep=2,og=4,tim=789991642567
33 STAT #3 id=1 cnt=1 pid=0 pos=1 obj=0 op='UPDATE SEQ$ (cr=1 pr=0 pw=0
time=195 us)'
34 STAT #3 id=2 cnt=1 pid=1 pos=1 obj=102 op='INDEX UNIQUE SCAN I_SEQ1
(cr=1 pr=0 pw=0 time=25 us)'
35 FETCH #2:c=0,e=1872,p=0,cr=1,cu=3,mis=0,r=1,dep=1,og=1,tim=789991643213
36 WAIT #1: nam='db file sequential read' ela= 33297 file#=4 block#=127140 blocks=1
obj#=54441 tim=789993165434
37 WAIT #1: nam='SQL*Net message to client' ela= 5 driver id=1413697536 #bytes=1
p3=0 obj#=54441 tim=789993165747
38 EXEC #1:c=1500000,e=1525863,p=1,cr=2,cu=8,mis=0,r=1,dep=0,og=1,tim=789993165858
39 WAIT #1: nam='SQL*Net message from client' ela= 232 driver id=1413697536 #bytes=1
p3=0 obj#=54441 tim=789993166272
40 XCTEND rlbk=0, rd_only=0
41 WAIT #0: nam='log file sync' ela= 168 buffer#=5320 p2=0 p3=0
obj#=54441 tim=789993166718
42 WAIT #0: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1
p3=0 obj#=54441 tim=789993166829
43 *** 2007-11-20 15:39:49.937
44 WAIT #0: nam='SQL*Net message from client' ela= 9864075 driver id=1413697536
#bytes=1 p3=0 obj#=54441 tim=790003031019
45 XCTEND rlbk=0, rd_only=1
46 STAT #2 id=1 cnt=1 pid=0 pos=1 obj=53073 op='SEQUENCE CUSTOMER_ID_SEQ
(cr=1 pr=0 pw=0 time=1878 us)'
47 STAT #2 id=2 cnt=1 pid=1 pos=1 obj=0 op='FAST DUAL (cr=0 pr=0 pw=0 time=15 us)'
