Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

database size from history

jason_goucfApr 8 2010 — edited Sep 25 2012

Hello everyone,
i know how to check db size from today "select round(sum(bytes / (1024*1024*1024))) "DB Size in MB" from dba_data_files;"
but what i want to do is go back 30 days , 60 days etc ... i am trying to do this for growth metrics.

can anyone help me with this script to grab db size from history?
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2012

Added on Apr 8 2010

#general-database-discussions

13 comments

6,896 views