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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

max size of a datafile

ashutoshNov 10 2010 — edited Nov 10 2010

Hi,
A database can have 64k datafiles. I want to know what can be the max size of a datafile. It is calculated by :
Maximum datafile size = db_block_size * maximum number of blocks,

Now how many blocks can be in a smallfile datafile and bigfile datafile.

Thanx
Ashutosh

This post has been answered by Renjith Madhavan on Nov 10 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2010

Added on Nov 10 2010

#general-database-discussions

11 comments

11,516 views