Database Reference
In-Depth Information
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 100 0.00 0.03 0 0 0 0
Execute 166 0.14 0.18 0 230 46 46
Fetch 199 0.01 0.04 5 449 0 489
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 465 0.15 0.27 5 679 46 535
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 5 0.01 0.03
213 user SQL statements in session.
166 internal SQL statements in session.
379 SQL statements in session.
********************************************************************************
Trace file: ten_ora_3172_img_load.trc
Trace file compatibility: 10.01.00
Sort options: exeela fchela
1 session in tracefile.
213 user SQL statements in trace file.
166 internal SQL statements in trace file.
379 SQL statements in trace file.
12 unique SQL statements in trace file.
128315 lines in trace file.
72 elapsed seconds in trace file.
Note the large discrepancy between total (recursive and non-recursive) elapsed time (0.43 s)
and the value for
elapsed seconds in trace file
(72 s). According to TKPROF, the following recursive
statement had the highest elapsed time:
update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize=
:9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13),
groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=
DECODE(:17,0,NULL,:17),scanhint=:18
where
ts#=:1 and file#=:2 and block#=:3
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 46 0.00 0.03 0 0 0 0
Execute 46 0.09 0.10 0 230 46 46
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 92 0.09 0.13 0 230 46 46
