오라클 물리적 제한 사항

1 ORACLE 11G 물리 DB 제한 Physical Database Limits[편집]

1.1 Database Block Size[편집]

Minimum 2048 bytes; must be a multiple of operating system physical block size

1.2 Database Block Size[편집]

Maximum Operating system dependent; never more than 32 KB

1.3 Database Blocks[편집]

Minimum in initial extent of a segment 2 blocks

1.4 Database Blocks[편집]

Maximum per datafile Platform dependent; typically 222 - 1 blocks

1.5 Controlfiles[편집]

Number of control files 1 minimum; 2 or more (on separate devices) strongly recommended

1.6 Controlfiles[편집]

Size of a control file Dependent on operating system and database creation options; maximum of 25,000 x (database block size)

1.7 Database files[편집]

Maximum per tablespace Operating system dependent; usually 1022

1.8 Database files[편집]

Maximum per database 65533 May be less on some operating systems Limited also by size of database blocks and by the DB_FILES initialization parameter for a particular instance

1.9 Database extents[편집]

Maximum per dictionary managed tablespace 4 GB * physical block size (with K/M modifier); 4 GB (without K/M modifier)

1.10 Database extents[편집]

Maximum per locally managed (uniform) tablespace 2 GB * physical block size (with K/M modifier); 2 GB (without K/M modifier)

1.11 Database file size[편집]

Maximum Operating system dependent. Limited by maximum operating system file size; typically 222 or 4 MB blocks ==== MAXEXTENTS ==== Default value Derived from tablespace default storage or DB_BLOCK_SIZE initialization parameter ==== MAXEXTENTS ==== Maximum Unlimited

1.12 Redo Log Files[편집]

Maximum number of logfiles Limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement Control file can be resized to allow more entries; ultimately an operating system limit

1.13 Redo Log[편집]

Files Maximum number of logfiles per group Unlimited

1.14 Redo Log File Size[편집]

Minimum size 4 MB

1.15 Redo Log File Size[편집]

Maximum Size Operating system limit; typically 2 GB

1.16 Tablespaces[편집]

Maximum number per database 64 K Number of tablespaces cannot exceed the number of database files because each tablespace must include at least one file

1.17 Bigfile Tablespaces[편집]

	Number of blocks	A bigfile tablespace contains only one datafile or tempfile, which can contain up to approximately 4 billion ( 232 ) blocks. The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32 K blocks and 32 TB for a tablespace with 8 K blocks.

1.18 Smallfile (traditional) Tablespaces[편집]

Number of blocks A smallfile tablespace is a traditional Oracle tablespace, which can contain 1022 datafiles or tempfiles, each of which can contain up to approximately 4 million (222) blocks.

1.19 External Tables file[편집]

	Maximum size	Dependent on the operating system.

An external table can be composed of multiple files.