Re: Database Growth for previous month

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Sat, 05 Jun 2010 19:37:52 +0200
Message-ID: <4C0A8B70.2030402_at_gmail.com>


>> Could you please help me is there any way to get the database growth
>> for the previous two months.
>>

[...]

If you use a recovery catalog with the report schema command (>= 9i?):

RMAN> report schema at time 'sysdate - 30';

RMAN> report schema at time 'sysdate - 61';

Of course, it will not show you how much space was actually used inside the datafiles ...

Regards
Dimitre

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jun 05 2010 - 12:37:52 CDT

Original text of this message