Database Reference
In-Depth Information
Because row source information wasn't written in the trace file in this case, and the user
CHRIS
has no privileges
for the objects referenced in this SQL statement, no information about the execution plan is given (see Chapter 10 for
detailed information about the privileges needed to execute the
EXPLAIN PLAN
statement). The output continues with
the wait events:
Elapsed times include waiting on following events:
Event waited on Times Waited Max. Wait Total Waited
----------------------------------- ------------ ---------- ------------
db file sequential read 5 0.00 0.01
After the report of all SQL statements, you can see the overall totals for execution statistics as well as parsing and
wait events. The only thing of note in this part is that nonrecursive SQL statements are separated from recursive SQL
statements:
OVERALL TOTALS FOR ALL
NON-RECURSIVE
STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 3 0.45 0.42 20 226 0 3
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.45 0.42 20 226 0 3
Misses in library cache during parse: 2
Misses in library cache during execute: 1
Elapsed times include waiting on following events:
Event waited on Times Waited Max. Wait Total Waited
----------------------------------- ------------ ---------- ------------
SQL*Net message to client 2 0.00 0.00
SQL*Net message from client 2 0.00 0.00
OVERALL TOTALS FOR ALL
RECURSIVE
STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 29 0.00 0.00 0 0 0 0
Fetch 10037 6.50 11.97 71569 38832 8 1000028
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 10068 6.50 11.97 71569 38832 8 1000028
Misses in library cache during parse: 2
Misses in library cache during execute: 2
Elapsed times include waiting on following events:
Event waited on Times Waited Max. Wait Total Waited
----------------------------------- ------------ ---------- ------------
db file sequential read 72 0.00 0.04
db file scattered read 530 0.06 2.79
direct path write temp 11002 0.00 0.51
