Re: Steps/DOC for Physical Standby with Real-Time Apply -Creation with Rman Tool.

It Gives me the Year as 2011 and month FEB ...Please can any one clarify , what I am missing out here.

The script below will list the details
of Database growth per month. It lists the total size of all datafiles, grouped by the month in which they are created.

SET PAGESIZE 5000

     SELECT
         TO_char(creation_time, 'RRRR Month') "Month"
       , SUM(bytes)/1024/1024 "Growth in Meg"
     FROM
         sys.v_$datafile
     WHERE creation_time > SYSDATE-365
     GROUP BY TO_CHAR(creation_time, 'RRRR Month');

--
http://www.freelists.org/webpage/oracle-l