Skip to Main Content
Forums

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 Growth

user13445377Jun 28 2012 — edited Oct 4 2012
How to find out the exact database growth in Oracle 10G.
I have tried with below query, but i am not getting the exact growth.. Please provide the details to find out the exact database growth


select to_char(creation_time,'RRRR month') "Month" , sum(bytes/1024/1024) "growth in KB" from v$datafile group by to_char(creation_time,'RRRR month');
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2012
Added on Jun 28 2012
#general-database-discussions
6 comments
734 views