 Oracle
Tips by BurlesonOracle10g 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
characteristics:
- An Oracle database can contain both bigfile and smallfile
tablespaces.
- System default is to create the traditional smallfile
tablespace.
- 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
manually managed:
- 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.
|
