Apply rate

Apply rate:
Following queries to find out the speed of media recovery in a standby database

SQL> set linesize 150
SQL> set pagesize 500
SQL> col type format a20
SQL> col ITEM format a20
SQL> col UNITS format a15
SQL> col SOFAR format 9999999
SQL> col comments format a20
SQL> col TOTAL format 999999
SQL> select * from v$recovery_progress;

START_TIME           TYPE                 ITEM                 UNITS              SOFAR   TOTAL TIMESTAMP            COMMENTS
-------------------- -------------------- -------------------- --------------- -------- ------- -------------------- --------------------
18-EYL-2014 01:02:19 Media Recovery       Log Files            Files                 18       0
18-EYL-2014 01:02:19 Media Recovery       Active Apply Rate    KB/sec               573       0
18-EYL-2014 01:02:19 Media Recovery       Average Apply Rate   KB/sec                14       0
18-EYL-2014 01:02:19 Media Recovery       Maximum Apply Rate   KB/sec               574       0
18-EYL-2014 01:02:19 Media Recovery       Redo Applied         Megabytes            182       0
18-EYL-2014 01:02:19 Media Recovery       Last Applied Redo    SCN+Time               0       0 18-EYL-2014 04:45:08 SCN: 03045961
18-EYL-2014 01:02:19 Media Recovery       Active Time          Seconds              145       0
18-EYL-2014 01:02:19 Media Recovery       Apply Time per Log   Seconds                7       0
18-EYL-2014 01:02:19 Media Recovery       Checkpoint Time per  Seconds                0       0
                                          Log

18-EYL-2014 01:02:19 Media Recovery       Elapsed Time         Seconds            13369       0
18-EYL-2014 01:01:54 Media Recovery       Log Files            Files                  1       1