Databases Reference
In-Depth Information
$ esqltrcprof -r 10.2 insert_cust.trcsess
Assuming ORACLE release 10.2 trace file.
Resource Profile
================
Response time: 11.391s; max(tim)-min(tim): 11.397s
…
ESQLTRCPROF Report Sections
ESQLTRCPROF reports consist of a resource profile at session level, statistics at session level,
statement level resource profiles, and statement level statistics for each statement encountered in
the trace file. The report starts with the session level section entitled “Resource Profile”.
Session Level Resource Profile
The resource profile for the trace file used in the previous case study is reproduced in the following
code example. The R and db block gets figures that were calculated manually are identical to
the figures reported by ESQLTRCPROF. The 7 ms of unknown time also matches the manual
calculation. The report includes the difference between the maximum and minimum timestamp
(
tim
) value found as “max(tim)-min(tim)” next to the response time.
$ esqltrcprof.pl ten_ora_6720_insert_customer.pl.trc
ORACLE version 10.2 trace file. Timings are in microseconds (1/1000000 sec)
Warning: WAIT event 'log file sync' for cursor 0 at line 61 without prior PARSING IN
CURSOR #0 - all waits for cursor 0 attributed to default unknown statement
with hash value -1
Resource Profile
================
Response time: 11.391s; max(tim)-min(tim): 11.397s
Total wait time: 9.898s
----------------------------
Note: 'SQL*Net message from client' waits for more than 0.005s are considered think
time
Wait events and CPU usage:
Duration Pct Count Average Wait Event/CPU Usage/Think Time
-------- ------ ------------ ---------- -----------------------------------
9.864s 86.59% 1 9.864075s think time
1.500s 13.17% 8 0.187500s total CPU
0.033s 0.29% 1 0.033297s db file sequential read
0.001s 0.01% 2 0.000400s SQL*Net message from client
0.000s 0.00% 1 0.000168s log file sync
0.000s 0.00% 3 0.000004s SQL*Net message to client
-0.007s -0.06% unknown
--------- ------- -----------------------------------------------------------
11.391s 100.00% Total response time
