Skip to Main Content

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

Comments

Your post doesn't have enough detail to identify a cause.

How did you install Instant Client? Did you set PATH?

Don't copy oci8.dll. It is too easy to get a conflicted set up.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 23 2012
Added on Apr 8 2010
13 comments
6,894 views