oracle mysql 体积大_ORACLE数据库容量最大能有多大

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.