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!

Big File vs Small file Tablespace

939393Jan 30 2012 — edited Sep 15 2013

Hi All,

I have a doubt and just want to confirm that which is better if i am using Big file instead of many small datafile for a tablespace or big datafiles for a tablespace. I think better to use Bigfile tablespace.

Kindly help me out wheather i am right or wrong and why.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 13 2013

Added on Jan 30 2012

#general-database-discussions

11 comments

57,772 views