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>
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-lReceived on Sat Jun 05 2010 - 12:37:52 CDT