Database Reference
In-Depth Information
---- DISK_READS=7, DISK_READS_PER_EX=7, BUFFER_GETS=2094540, BUFFER_GETS_PER_EX=2094540
---- DIRECT_WRITES=0, DIRECT_WRITES_PER_EX=0
---- PARSE_CALLS=1, EXECUTIONS=1, ROWS_PROCESSED=1
---- IS_SHAREABLE=Y, IS_BIND_SENSITIVE=N, IS_BIND_AWARE=N
---- CPU/Elapsed Time (sec.) total=296.8543/303.4862, per ex.=296.8543/303.4862
---- PL/SQL Exec Time (sec.) total=81.3827, per ex.=81.3827
---- JAVA Exec Time (sec.) total=0.0000, per ex.=0.0000
---- Application Wait Time (sec.) total=0.0000, per ex.=0.0000
---- Concurrency Wait Time (sec.) total=0.0012, per ex.=0.0012
---- Cluster Wait Time (sec.) total=0.0000, per ex.=0.0000
---- User IO Wait Time (sec.) total=0.1260, per ex.=0.1260
---- IO_INTERCONNECT_BYTES=57344, IO_INTERCONNECT_BYTES_PER_EX=57344
---- Service : XXXXX
---- Module : sqlplus.exe
---- USER="SYS", SCHEMA="SYS", OPTIMIZER_MODE=ALL_ROWS, OPTIMIZER_ENV_HASH_VALUE=1246637239,
USERS_OPEN=1, USERS_EXEC=0, LAST_ACTIVE_TIME=03.08.2012 13:21:38
---- SQL_ID=>3fj62gv96ntpb<, ADDRESS=>000007FF079696A0<, HASH_VALUE=>3530188459<,
OLD_HASH_VALUE=>3305405061<, CHILD_NUMBER=>0<
begin
for i in 1..2000000 loop
insert into t1 values (i, i*10, i*100, i*1000, i*10000, i*1000000);
end loop;
commit;
end;
Die oberen Informationen sind in der View V$SQL ermittelt. Nach der Auswertung der
jeweiligen Trace-Datei mit der Utility tkprof fand ich in der Ausgabe meinen Cursor und
den rekursiven Cursor für das Insert-Kommando.
EHJLQ
IRULLQORRS
LQVHUWLQWRWYDOXHVLLLLLL
HQGORRS
FRPPLW
HQG
FDOOFRXQWFSXHODSVHGGLVNTXHU\FXUUHQWURZV
3DUVH
([HFXWH
)HWFK
WRWDO
64/,'DZG[PJSXU]
3ODQ+DVK
,16(57,1727
9$/8(6
%%%%%%
FDOOFRXQWFSXHODSVHGGLVNTXHU\FXUUHQWURZV
3DUVH
([HFXWH
)HWFK
WRWDO
