Tips by Burleson
Oracle10g Bigfile Tablespace
A bigfile tablespace (BFT) is a tablespace containing a single
file that can have a very large size.
Bigfile Tablespace Overview
The traditional tablespace is referred to as a smallfile
tablespace (SFT). A smallfile tablespace contains multiple,
relatively small files. The bigfile tablespace has the following
- An Oracle database can contain both bigfile and smallfile
- System default is to create the traditional smallfile
- The SYSTEM and SYSAUX tablespaces are always created using
the system default type.
- Bigfile tablespaces are supported only for locally managed
tablespaces with automatic segment-space management.
There are two exceptions when bigfile tablespace segments are
- Locally managed undo tablespace
- Temporary tablespace
Bigfile tablespaces are intended to be used with Automated Storage
Management (ASM) (see Chapter 1) or other logical volume managers
that support RAID. However, you can also use it without ASM.