Oracle
Tips by BurlesonOracle10g 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.
Maximum Database Size
The BFT extended the maximum size of tablespace and database.
Let’s take a look at the two formulas that calculate the maximum
size of data file and database.
The maximum data file size is calculated by:
Maximum datafile size = db_block_size * maximum number of
blocks
The maximum amount of data in an Oracle database is calculated
by:
Maximum database size = maximum datafile size * maximum number
of datafile
The maximum number of datafiles in Oracle9i and Oracle 10g
Database is 65,536. However, the maximum number of blocks in a
data file increase from 4,194,304 (4 million) blocks to
4,294,967,296 (4 billion) blocks.
The maximum amount of data for a 32K block size database is
eight petabytes (8,192 Terabytes) in Oracle9i.
BLOCK SIZE |
MAXIMUM DATA FILE SIZE |
MAXIMUM DATABASE SIZE |
32 K |
128 GB |
8,388,608 GB |
16 K |
64 GB |
4,194,304 GB |
8 K |
32 GB |
2,097,152 GB |
4 K |
16 GB |
1,048,579 GB |
2 K |
8 GB |
524,288 GB |
Table 3.1 Maximum Database Size in Oracle9i
The maximum amount of data for a 32K block size database is
eight exabytes (8,388,608 Terabytes) in Oracle 10g.
BLOCK SIZE |
MAXIMUM DATA FILE SIZE |
MAXIMUM DATABASE SIZE |
32 K |
131,072 GB |
8,589,934,592 GB |
16 K |
65,536 GB |
4,294,967,296 GB |
8 K |
32,768 GB |
2,147,483,648 GB |
4 K |
16,384 GB |
1,073,741,824 GB |
2 K |
8,192 GB |
536,870,912 GB |
Table 3.2 Maximum Database Size in Oracle 10g
As you can see, with the new BFT addressing scheme, Oracle 10g
can contain astronomical amounts of data within a single database. |