Database Reference
In-Depth Information
RETURNING id INTO :id
DB Call Count Elapsed CPU Disk Query Current Rows
------- -------- ---------- ---------- -------- -------- -------- --------
PARSE 1 0.0001s 0.0000s 0 0 0 0
EXEC 1 1.5259s 1.5000s 1 2 8 1
FETCH 0 0.0000s 0.0000s 0 0 0 0
------- -------- ---------- ---------- -------- -------- -------- --------
Total 2 1.5259s 1.5000s 1 2 8 1
Wait Event/CPU Usage/Think Time Duration Count
---------------------------------------- ---------- --------
total CPU 1.500s 2
db file sequential read 0.033s 1
SQL*Net message from client 0.000s 1
SQL*Net message to client 0.000s 1
Hash Value: 1168215557 - Total Elapsed Time (excluding think time): 0.002s
SELECT CUSTOMER_ID_SEQ.NEXTVAL FROM DUAL
DB Call Count Elapsed CPU Disk Query Current Rows
------- -------- ---------- ---------- -------- -------- -------- --------
PARSE 1 0.0001s 0.0000s 0 0 0 0
EXEC 1 0.0001s 0.0000s 0 0 0 0
FETCH 1 0.0019s 0.0000s 0 1 3 1
------- -------- ---------- ---------- -------- -------- -------- --------
Total 3 0.0020s 0.0000s 0 1 3 1
Wait Event/CPU Usage/Think Time Duration Count
---------------------------------------- ---------- --------
total CPU 0.000s 3
Execution Plan:
Step Parent Rows Row Source
---- ------ -------- ------------------------------------------------------------
1 0 1 SEQUENCE CUSTOMER_ID_SEQ (cr=1 pr=0 pw=0 time=1878 us)
(object_id=53073)
2 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=15 us)
Hash Value: 740818757 - Total Elapsed Time (excluding think time): 0.001s
alter session set events '10046 trace name context forever, level 8'
