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:

The maximum amount of data in an Oracle database is calculated by:

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/308563/viewspace-171937/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/308563/viewspace-171937/