Database Reference
In-Depth Information
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- -------------------
Begin Snap: 291 07-Sep-07 06:20:07 21 6.7 SID-139-perl.exe-in
End Snap: 301 07-Sep-07 06:24:44 21 6.7 SID-139-perl.exe-in
Elapsed: 4.62 (mins)
Session Wait Events DB/Inst: TEN/TEN1 Snaps: 291-301
Session Id: 139 Serial#: 41757
-> ordered by wait time desc, waits desc (idle events last)
Total Wait
Event Waits Timeouts Time (s) WT
---------------------------- ------------ ---------- ---------- ----------
Waits
/txn
--------
log file switch completion 3 1 1 345.605667
3.0
db file sequential read 13 0 0 4.61123077
13.0
control file sequential read 26 0 0 .954307692
26.0
control file parallel write 6 0 0 2.56516667
6.0
db file scattered read 4 0 0 3.045
4.0
log file sync 2 0 0 5.1105
2.0
latch: library cache 1 0 0 0
1.0
SQL*Net message from client 283,496 0 72 .254345627
########
SQL*Net message to client 283,496 0 1 .004825056
########
Session Time Model Stats DB/Inst: TEN/TEN1 Snaps: 291-301
Session Id: 139 Serial#: 41757
-> Total Time in Database calls 182.9s (or 182854062us)
-> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % of DB time
----------------------------------- -------------------- ------------
DB CPU 179.2 98.0
sql execute elapsed time 176.1 96.3
sequence load elapsed time 32.1 17.6
PL/SQL execution elapsed time 6.7 3.7
Search WWH ::




Custom Search