Re: Steps/DOC for Physical Standby with Real-Time Apply -Creation with Rman Tool.
- From: Sheldon Quinny <sheldonquinny@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Feb 2012 15:27:23 +0300
Hi All,
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');
--
//www.freelists.org/webpage/oracle-l
Other related posts:
