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 |
|
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 |
|
2 K | 8,192 GB | 536,870,912 GB |
Table 3.2: Maximum database size in Oracle 10g.
