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 SIZEMAXIMUM DATA FILE SIZEMAXIMUM DATABASE SIZE
32 K128 GB8,388,608 GB
16 K64 GB4,194,304 GB
8 K32 GB2,097,152 GB
4 K16 GB1,048,579 GB
2 K8 GB524,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 SIZEMAXIMUM DATA FILE SIZEMAXIMUM DATABASE SIZE
32 K131,072 GB8,589,934,592 GB
16 K65,536 GB4,294,967,296 GB
8 K32,768 GB2,147,483,648 GB
4 K16,384 GB1,073,741,824 GB
2 K8,192 GB536,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.