Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 17 - Oracle’s Grid Integration Technologies

Bigfile Tablespace Overview

A bigfile tablespace (BFT) is a tablespace containing a single file that can have a very large size. 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 and Temporary tablespace.

Bigfile tablespaces are intended to be used with Automated Storage Management (ASM) or other logical volume managers that support RAID.  However, you can also use it without ASM.

Bigfile Tablespace Benefits

Bigfile tablespace has the following benefits:

• It simplifies large database tablespace management by reducing the number of datafiles needed.
   

• It simplifies datafile management with Oracle-managed files and Automated Storage Management (ASM) by eliminating the need for adding new datafiles and dealing with multiple files.
   

• It allows you to create a bigfile tablespace of up to eight exabytes (eight million terabytes) in size, and significantly increase the storage capacity of an Oracle database.
   

• It follows the concept that a tablespace and a datafile are logically equivalent.

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA

For more information, please visit www.praetoriate.com or email .