This content has been marked as final. Show 6 replies
For completed database capacity planning you have to look into different Areas of database.
for checking the growth of Database per Month you can use this script.
select to_char(creation_time, 'RRRR Month') "Month",
sum(bytes)/1024/1024 "Growth in MM",
sum(bytes)/1024/1024/1024 "Growth in GB"
where creation_time > SYSDATE-365
group by to_char(creation_time, 'RRRR Month');
it displays the growth of the database month & years wise in Mega bytes & Giga Bytes also.
for checking the growth of Database per Month you can use this script.That would show the current size of the datafiles by the month they were added.
It doesn't show the growth in database objects.
It doesn't take into account that maybe the datafile was added with size 1M and then extended 5,000 times to its current size.
It's not a useful query in this context at all
Similar issue mention here many times, please use search mechanisim:
Re: OEM Database monitoring scripts
http://docs.oracle.com/cd/B16240_01/doc/em.102/e10954/sizing.htm << from OEM
I suggest please also see below thread
DB Growth per month from last 7 months
How to monitor the Database growth ???
Database Growth %
How to Monitor a Schema Growth in a Database?