% Blocks changed per Read: 61.55 Recursive Call %: 54.04
Rollback per transaction %: 0.00 Rows per Sort: 2.40
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 91.01 In-memory Sort %: 100.00
Library Hit %: 100.03 Soft Parse %: 100.00
Execute to Parse %: 26.99 Latch Hit %: 99.10
Parse CPU to Parse Elapsd %: 3.93 % Non-Parse CPU: 99.53
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 91.40 91.36
% SQL with executions>1: 1.65 1.71
% Memory for SQL w/exec>1: 2.27 2.34
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
log file sync 1,143,542 48,685 89.62
db file scattered read 130,666 2,147 3.95
db file sequential read 74,154 1,231 2.27
db file parallel write 5,864 1,016 1.87
CPU time 928 1.71
-------------------------------------------------------------
Wait Events for DB: test Instance: test Snaps: 496 -497
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
% Blocks changed per Read: 50.19 Recursive Call %: 52.70
Rollback per transaction %: 0.00 Rows per Sort: 3.45
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 76.76 In-memory Sort %: 100.00
Library Hit %: 100.01 Soft Parse %: 99.98
Execute to Parse %: 24.48 Latch Hit %: 99.68
Parse CPU to Parse Elapsd %: 4.34 % Non-Parse CPU: 99.73
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 91.44 91.44
% SQL with executions>1: 1.82 1.94
% Memory for SQL w/exec>1: 2.58 2.90
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
log file sync 477,560 14,391 80.63
db file scattered read 185,231 2,061 11.55
CPU time 661 3.70
db file parallel write 2,524 384 2.15
db file sequential read 27,470 292 1.63
-------------------------------------------------------------
Wait Events for DB: test Instance: test Snaps: 505 -506
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
log file sync 477,560 0 14,391 30 1.2
db file scattered read 185,231 0 2,061 11 0.5
db file parallel write 2,524 0 384 152 0.0
db file sequential read 27,470 0 292 11 0.1
control file parallel write 1,210 0 34 28 0.0
log file parallel write 213,549 0 11 0 0.5
row cache lock 10,671 0 6 1 0.0
single-task message 6 0 4 633 0.0
control file sequential read 586 0 2 3 0.0
log file switch completion 17 0 2 109 0.0
SQL*Net message from dblink 72 0 0 5 0.0
latch free 236 176 0 1 0.0
process startup 3 0 0 71 0.0
direct path read 82 0 0 2 0.0
direct path write 84 0 0 2 0.0
db file parallel read 1 0 0 94 0.0
log file single write 2 0 0 14 0.0
LGWR wait for redo copy 666 0 0 0 0.0
SQL*Net more data to client 433 0 0 0 0.0
log file sequential read 2 0 0 9 0.0
SQL*Net break/reset to clien 14 0 0 0 0.0
buffer busy waits 97 0 0 0 0.0
SQL*Net message to dblink 72 0 0 0 0.0
undo segment extension 1 1 0 0 0.0
SQL*Net message from client 1,473,483 0 138,444 94 3.8
virtual circuit status 120 120 3,515 29294 0.0
wakeup time manager 116 116 3,378 29121 0.0
jobq slave wait 66 63 191 2889 0.0
SQL*Net message to client 1,473,484 0 3 0 3.8
-------------------------------------------------------------
Background Wait Events for DB: test Instance: test Snaps: 505 -506
-> ordered by wait time desc, waits desc (idle events last)