"오라클 물리적 제한 사항"의 두 판 사이의 차이
DB CAFE
| (같은 사용자의 중간 판 하나는 보이지 않습니다) | |||
| 1번째 줄: | 1번째 줄: | ||
=== ORACLE 11G 물리 DB 제한 Physical Database Limits === | === ORACLE 11G 물리 DB 제한 Physical Database Limits === | ||
| − | |||
| − | |||
| − | |||
| − | |||
==== Database Block Size ==== | ==== Database Block Size ==== | ||
Minimum 2048 bytes; | Minimum 2048 bytes; | ||
must be a multiple of operating system physical block size | must be a multiple of operating system physical block size | ||
| − | ==== Database Block Size ==== Maximum Operating system dependent; never more than 32 KB | + | ==== Database Block Size ==== |
| − | ==== Database Blocks ==== Minimum in initial extent of a segment 2 blocks | + | Maximum Operating system dependent; never more than 32 KB |
| − | ==== Database Blocks ==== Maximum per datafile Platform dependent; typically 222 - 1 blocks | + | ==== Database Blocks ==== |
| − | ==== Controlfiles ==== Number of control files 1 minimum; 2 or more (on separate devices) strongly recommended | + | Minimum in initial extent of a segment 2 blocks |
| − | ==== Controlfiles ==== Size of a control file Dependent on operating system and database creation options; maximum of 25,000 x (database block size) | + | ==== Database Blocks ==== |
| − | ==== Database files ==== Maximum per tablespace Operating system dependent; usually 1022 | + | Maximum per datafile Platform dependent; typically 222 - 1 blocks |
| − | ==== Database files ==== Maximum per database 65533 May be less on some operating systems | + | ==== Controlfiles ==== |
| − | + | Number of control files 1 minimum; 2 or more (on separate devices) strongly recommended | |
| + | ==== Controlfiles ==== | ||
| + | Size of a control file Dependent on operating system and database creation options; maximum of 25,000 x (database block size) | ||
| + | ==== Database files ==== | ||
| + | Maximum per tablespace Operating system dependent; usually 1022 | ||
| + | ==== 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 | ||
| − | ==== Database extents ==== Maximum per dictionary managed tablespace 4 GB * physical block size (with K/M modifier); 4 GB (without K/M modifier) | + | ==== Database extents ==== |
| − | ==== Database extents ==== Maximum per locally managed (uniform) tablespace 2 GB * physical block size (with K/M modifier); 2 GB (without K/M modifier) | + | Maximum per dictionary managed tablespace 4 GB * physical block size (with K/M modifier); 4 GB (without K/M modifier) |
| − | ==== Database file size ==== Maximum Operating system dependent. Limited by maximum operating system file size; typically 222 or 4 MB blocks | + | ==== Database extents ==== |
| + | Maximum per locally managed (uniform) tablespace 2 GB * physical block size (with K/M modifier); 2 GB (without K/M modifier) | ||
| + | ==== 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 ==== Default value Derived from tablespace default storage or DB_BLOCK_SIZE initialization parameter | ||
==== MAXEXTENTS ==== Maximum Unlimited | ==== MAXEXTENTS ==== Maximum Unlimited | ||
| − | ==== Redo Log Files ==== Maximum number of logfiles Limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement | + | ==== 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 | Control file can be resized to allow more entries; ultimately an operating system limit | ||
| − | ==== Redo Log ==== Files Maximum number of logfiles per group Unlimited | + | ==== Redo Log ==== |
| − | ==== Redo Log File Size ==== Minimum size 4 MB | + | Files |
| − | ==== Redo Log File Size ==== Maximum Size Operating system limit; typically 2 GB | + | Maximum number of logfiles per group Unlimited |
| + | ==== Redo Log File Size ==== | ||
| + | Minimum size 4 MB | ||
| + | ==== Redo Log File Size ==== | ||
| + | Maximum Size Operating system limit; typically 2 GB | ||
==== Tablespaces ==== | ==== Tablespaces ==== | ||
Maximum number per database 64 K | Maximum number per database 64 K | ||
| 39번째 줄: | 49번째 줄: | ||
Maximum size Dependent on the operating system. | Maximum size Dependent on the operating system. | ||
An external table can be composed of multiple files. | An external table can be composed of multiple files. | ||
| + | [[Category:oracle]] | ||
2019년 12월 22일 (일) 15:19 기준 최신판
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
목차
- 1 ORACLE 11G 물리 DB 제한 Physical Database Limits
- 1.1 Database Block Size
- 1.2 Database Block Size
- 1.3 Database Blocks
- 1.4 Database Blocks
- 1.5 Controlfiles
- 1.6 Controlfiles
- 1.7 Database files
- 1.8 Database files
- 1.9 Database extents
- 1.10 Database extents
- 1.11 Database file size
- 1.12 Redo Log Files
- 1.13 Redo Log
- 1.14 Redo Log File Size
- 1.15 Redo Log File Size
- 1.16 Tablespaces
- 1.17 Bigfile Tablespaces
- 1.18 Smallfile (traditional) Tablespaces
- 1.19 External Tables file
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.