What Is The Maximum Tablespace Size And Database Limit For An Oracle Database ? (文档 ID 1372905.1)

What Is The Maximum Tablespace Size And Database Limit For An Oracle Database ? (文档 ID 1372905.1)

转到底部

---

In this Document Goal   Solution APPLIES TO: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2] Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2] Information in this document applies to any platform. GOAL What is the maximum value for the following in Oracle 10g and 11g : database size tablespace size file size SOLUTION Small file database For a small file database, the Oracle database has the following limits : maximum number of datafiles is : 65533 maximum data blocks per datafile : 2^22 -1 = 4194303 maximum datafile size = db_block_size * maximum number of blocks maximum db_block_size = 32 K maximum tablespace size = 1022 * max database file Resulting values are: maximum datafile size = 32 * 4194303 = 128 GB maximum tablespace size = 1022 * 128 GB = 130816 GB maximum database size = 128 G * 65533 = 8388224 GB Big file database For a big file database, the Oracle database has the following limits : maximum number of datafiles is : 65533 maximum data blocks per datafile : 2^32 = 4294967296 maximum datafile size = db_block_size * maximum number of blocks max db_block_size = 32 K maximum tablespace size = size of big datafile Resulting values are: maximum datafile size = 32 * 4294967296 = 128 TB maximum tablespace size = 128 TB maximum database size = 128 T * 65533 =8388224 TB Note: If you tried to increase the maxsize of a datafile to beyond the limits explained in this document the operation will fail with ORA-3206 error.