AWR Redo

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:          1,451,121.63            272,624.47

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Redo NoWait %:   99.84


                                                                  Avg          
                                       %Time       Total Wait    wait     Waits
Wait Class                      Waits  -outs         Time (s)    (ms)      /txn
-------------------- ---------------- ------ ---------------- ------- ---------
Configuration                  63,949     .6              998      16       0.7

Wait Events                  DB/Inst: CCMNASP1/CCMNASP1N1  Snaps: 22501-22531
-> 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          
                                             %Time  Total Wait    wait     Waits
Event                                 Waits  -outs    Time (s)    (ms)      /txn
---------------------------- -------------- ------ ----------- ------- ---------      
log file sequential read             32,177     .0         648      20       0.3
log file switch(ckpt incomp          10,330    1.0         572      55       0.1
log file sync                        59,236     .0         183       3       0.6
log file switch completion            1,706    3.5         138      81       0.0
log file switch (archiving n          2,927     .2         121      41       0.0
Log archive I/O                      27,030     .0          22       1       0.3


Statistic                                     Total     per Second     per Trans
-------------------------------- ------------------ -------------- -------------
redo log space requests                     114,499            6.4           1.2
redo log space wait time                     85,008            4.7           0.9
redo ordering marks                       1,597,131           88.7          16.7
redo size                            26,127,511,776    1,451,121.6     272,624.5
redo subscn max counts                      163,257            9.1           1.7
redo synch time                              18,839            1.1           0.2
redo synch writes                            58,819            3.3           0.6
redo wastage                            151,718,608        8,426.5       1,583.1
redo write time                             131,085            7.3           1.4
redo writer latching time                       136            0.0           0.0
redo writes                                 499,869           27.8           5.2


Instance Activity Stats - Thread ActivityDB/Inst: CCMNASP1/CCMNASP1N1  Snaps: 
-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic                                     Total  per Hour
-------------------------------- ------------------ ---------
log switches (derived)                          711    142.16
          -------------------------------------------------------------  


Instance Recovery Stats       DB/Inst: CCMNASP1/CCMNASP1N1  Snaps: 22501-22531
-> B: Begin snapshot,  E: End snapshot

  Targt  Estd                                  Log File Log Ckpt     Log Ckpt 
  MTTR   MTTR   Recovery  Actual    Target       Size    Timeout     Interval 
   (s)    (s)   Estd IOs Redo Blks Redo Blks  Redo Blks Redo Blks   Redo Blks 
- ----- ----- ---------- --------- --------- ---------- --------- ------------
B     0     0        412      1023      1460     184320      1460          N/A
E     0     0        305       586    184320     184320       N/A          N/A
          -------------------------------------------------------------