Database Reference
In-Depth Information
43.387s 100.00% Total response time
Total number of roundtrips (SQL*Net message from/to client): 188696
CPU usage breakdown
------------------------
parse CPU: 0.00s (12 PARSE calls)
exec CPU: 16.25s (188707 EXEC calls)
fetch CPU: 0.00s (22 FETCH calls)
…
The most expensive SQL statement was an
INSERT
statement on the table
CUSTOMER
identi-
fied earlier by accessing
X$BH
.
Statements Sorted by Elapsed Time (including recursive resource utilization)
==============================================================================
Hash Value: 1256130531 - Total Elapsed Time (excluding think time): 42.608s
INSERT INTO customer(id, name, phone)
VALUES (customer_id_seq.nextval, :name, :phone)
RETURNING id INTO :id
DB Call Count Elapsed CPU Disk Query Current Rows
------- -------- ---------- ---------- -------- -------- -------- --------
PARSE 0 0.0000s 0.0000s 0 0 0 0
EXEC 188695 19.6005s 16.2344s 4 4241 581188 188695
FETCH 0 0.0000s 0.0000s 0 0 0 0
------- -------- ---------- ---------- -------- -------- -------- --------
Total 188695 19.6005s 16.2344s 4 4241 581188 188695
Wait Event/CPU Usage/Think Time Duration Count
---------------------------------------- ---------- --------
SQL*Net message from client 22.439s 188692
total CPU 16.234s 188695
think time 0.774s 3
enq: TX - index contention 0.642s 362
buffer busy waits 0.625s 4543
SQL*Net message to client 0.569s 188694
log file switch completion 0.329s 4
log buffer space 0.170s 5
db file sequential read 0.023s 2
latch: library cache 0.002s 20
latch: cache buffers chains 0.001s 13
latch free 0.001s 10
buffer deadlock 0.000s 28
latch: cache buffers lru chain 0.000s 10
latch: library cache pin 0.000s 1
