Database size

[indirashyam]

Hi All,

I want to know growth status of oracle database.

I gave the below command:

SQL>set pagesize 500
SQL>tti "Database growth per month for last year"

SQL>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');
/

no rows selected


I want to find the growth status. Please can any one help me in finding this.

[PAVB]

That means no datafile was added during the last 364 days.
Are datafiles set to autogrowth?

[indirashyam]

That means no datafile was added during the last 364 days.
Are datafiles set to autogrowth?

Hi Paul,

All the datafiles are setted as autogrowth only

[davey23uk]

it isnt logged when datafiles autoextend, so you cannot find out