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!

What is demerit of using Bigfile tablespace ?

teradata0802Apr 12 2015 — edited Apr 14 2015

We use Oracle 11g on Windows2008R2 for Web application backend DB.

Some of tablespaces size are over 32GB.

So, we creates several datafiles less than 32GB for those tablespaces.

Is thereĀ  any demerits or causions to use Bigfile tablespace ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2015
Added on Apr 12 2015
12 comments
2,072 views