Re: Steps/DOC for Physical Standby with Real-Time Apply -Creation with Rman Tool.
Date: Wed, 15 Feb 2012 15:27:23 +0300
Trying to execute this statement on a Oracle DB 10.2.4.0 Windows 2003R2
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');Received on Wed Feb 15 2012 - 06:27:23 CST