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 and Datafile size

839439Sep 5 2011 — edited Sep 6 2011
Hello

Can anyone explain how the size of the datafile is dependent on OS 32-bit and 64-bit ??
As far my knowledge, i calculate the max size of database as (max. number of datafile) * (maximum size of the datafile ) .

and i calculate the max. size of data-file as (db_block_size) * ( max number of block) where max. no. of block can obtained from dba_data_files.

So where is it O.S dependent ??

thanks in advance

Regards

Neeraj
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2011
Added on Sep 5 2011
20 comments
1,086 views