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!

v$datafile

814590Jun 3 2011 — edited Jun 3 2011

Hi,

I need to calculate the database size for the years 2008/2009.

I used this sql query for that -> select sum(bytes)/(1024/1024/1024) "in GB" from v$datafile where to_char(creation_time,'YYYY')='2009'

I have a question here,

Is that query gives the space added in 2009 or size of the database till 2009

Please clarify me

Thanks
Vijay.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2011

Added on Jun 3 2011

#general-database-discussions

8 comments

366 views