Size of Database

[cjgrozo]

Hi,

I need know how i can know the growing cronology of the database since his creation. Exist any way?? any views???

Thanks

Javier

[davey23uk]

what on earth is a 'growing cronology' ?

[cjgrozo]

yes, i need know the size of growing mounth for mounth. How was growing since the creation.

[davey23uk]

you wont know unless you have been monitoring it yourself - you also dont mention version

[cjgrozo]

The version is 10G

[cjgrozo]

the repository is configured in 7 days.

[malay_biswal]

select sum(bytes)/(1024*1024*1024) "size in GB" from dba_data_files
for total DB size

select sum(bytes)/(1024*1024*1024) "size in GB" from dba_segments
for used size.

[davey23uk]

select sum(bytes)/(1024*1024*1024) "size in GB" from dba_data_files
for total DB size

select sum(bytes)/(1024*1024*1024) "size in GB" from dba_segments
for used size.

and how does that in any way answer his question about the growth of the database since creation?

[cjgrozo]

yes, for example, which was the size in November, December, January, etc.
Exist any views with this information?? How was growing since November for example, months by months.

[monto1]

As said by davey you need to monitor it every month in future by running the query provided by malay.