|
1 54.1
-------------------------------------------------------------
Recovery Progress Stats DB/Inst: dg2/dg2 End Snap: 2
-> End Snapshot Time: 23-Apr-14 14:46:05
-> ordered by Recovery Start Time desc, Units, Item asc
Recovery Start Time Item Sofar Units Redo Timestamp
------------------- ----------------- -------------- ------- ------------------
23-Apr-14 14:30:54 Log Files 2 Files
23-Apr-14 14:30:54 Active Apply Rate 575 KB/sec
23-Apr-14 14:30:54 Average Apply Rat 23 KB/sec
23-Apr-14 14:30:54 Maximum Apply Rat 582 KB/sec
23-Apr-14 14:30:54 Redo Applied 21 Megabyt
23-Apr-14 14:30:54 Last Applied Redo 0 SCN+Tim 23-Apr-14 14:46:06
23-Apr-14 14:30:54 Active Time 26 Seconds
23-Apr-14 14:30:54 Apply Time per Lo 3 Seconds
23-Apr-14 14:30:54 Checkpoint Time p 0 Seconds
23-Apr-14 14:30:54 Elapsed Time 911 Seconds
23-Apr-14 14:30:54 Standby Apply Lag 0 Seconds
-------------------------------------------------------------
Time Model System Stats DB/Inst: dg2/dg2 Snaps: 1-2
-> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % DB time
----------------------------------- -------------------- ---------
parse time elapsed 2.8 25.4
hard parse elapsed time 2.7 25.0
DB CPU 2.5 23.4
sql execute elapsed time 2.0 18.6
hard parse (sharing criteria) elaps 0.3 2.5
repeated bind elapsed time 0.0 .0
DB time 10.9
background elapsed time 14.1
background cpu time 2.7
-------------------------------------------------------------
Wait Events DB/Inst: dg2/dg2 Snaps: 1-2
-> s - second, cs - centisecond, ms - millisecond, us - microsecond
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait
Event Waits -outs Time (s) (ms)
---------------------------------------- ------------ ------ ---------- ------
Standby redo I/O 543 0 8 15
control file parallel write 587 0 7 12
db file async I/O submit 24 0 1 52
db file sequential read 31 0 1 23
db file parallel read 4 0 0 94
RFS write 613 0 0 0
Disk file operations I/O 1,096 0 0 0
library cache lock 8 0 0 10
control file sequential read 5,657 0 0 0
RFS dispatch 622 0 0 0
Data file init write 24 0 0 1
log file sequential read 1,087 0 0 0
os thread startup 1 0 0 17
RFS random i/o 543 0 0 0
RFS ping 9 0 0 1
latch free 104 0 0 0
db file single write 2 0 0 2
SQL*Net more data to client 6 0 0 0
latch: shared pool 1 0 0 2
SQL*Net message from client 899 0 1,616 1798
DIAG idle wait 1,088 100 1,089 1001
MRP redo arrival 623 0 544 873
shared server idle wait 18 100 540 30007
SQL*Net more data from client 11 0 0 4
SQL*Net message to client 899 0 0 0
-------------------------------------------------------------
Background Wait Events DB/Inst: dg2/dg2 Snaps: 1-2
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait
Event Waits -outs Time (s) (ms)
---------------------------------------- ------------ ------ ---------- ------
control file parallel write 551 0 7 13
db file async I/O submit 24 0 1 52
db file parallel read 4 0 0 94
Disk file operations I/O 1,096 0 0 0
library cache lock 5 0 0 14
control file sequential read 5,166 0 0 0
Data file init write 24 0 0 1
log file sequential read 1,087 0 0 0
os thread startup 1 0 0 17
latch free 104 0 0 0
db file si |