Database Reference
In-Depth Information
FETCH 0 0.0000s 0.0000s 0 0 0 0
------- -------- ---------- ---------- -------- -------- -------- --------
Total 0 0.0000s 0.0000s 0 0 0 0
Wait Event/CPU Usage/Think Time Duration Count
---------------------------------------- ---------- --------
think time 9.864s 1
log file sync 0.000s 1
SQL*Net message to client 0.000s 1
total CPU 0.000s 0
SQL Identifiers and Oracle11 g Trace Files
The latest release of ESQLTRCPROF supports Oracle11 g extended SQL trace files. It includes
the SQL identifier, module, action, and recursive call depth in the header of each statement-
level resource profile. SQL identifiers were introduced with Oracle10 g , but are not emitted to
SQL trace files prior to Oracle11 g . Thus, merely ESQLTRCPROF reports based on Oracle11 g
trace files contain SQL identifiers. Following is an example:
Statements Sorted by Elapsed Time (including recursive resource utilization)
==============================================================================
Hash Value: 1256130531 - Total Elapsed Time (excluding think time): 0.102s
SQL Id : b85s0yd5dy1z3 Module 'insert_perf5.pl' Action 'undefined'
Dependency Level: 0
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 1 0.0002s 0.0000s 0 0 0 0
EXEC 10 0.0956s 0.0313s 5 27 36 10
FETCH 0 0.0000s 0.0000s 0 0 0 0
------- -------- ---------- ---------- -------- -------- -------- --------
Total 11 0.0958s 0.0313s 5 27 36 10
Wait Event/CPU Usage/Think Time Duration Count
---------------------------------------- ---------- --------
total CPU 0.031s 11
db file sequential read 0.021s 3
SQL*Net message from client 0.006s 10
SQL*Net message to client 0.000s 10
Search WWH ::




Custom Search