Oracle Physical Database Limits

chenoracle發表於2022-12-19
OracleDatabaseMIT
Item Type of Limit Limit Value
Database Block Size Minimum 2048 bytes; must be a multiple of operating system physical block size
2048位元組；必須是作業系統物理塊大小的倍數
Database Block Size Maximum Operating system dependent; never more than 32 KB  
依賴於作業系統；不超過32 KB
Database Blocks Minimum in initial extent of a segment 2 blocks
Database Blocks Maximum per datafile Platform dependent; typically 2的22方 - 1 blocks
依賴於平臺；通常為 2的22方 - 1塊，如果單個塊8KB大小，單個資料檔案最大32GB。
Controlfiles Number of control files 1 minimum; 2 or more (on separate devices) strongly recommended
至少1個；強烈建議使用2個或更多（在單獨的裝置上）
Controlfiles Size of a control file Maximum of 201031680 logical blocks
最多201031680個邏輯塊
Database files Maximum per tablespace Operating system dependent; usually 1022
依賴於作業系統；通常為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
還受資料庫塊大小和特定例項的DB_FILES初始化引數的限制
Database extents Maximum per dictionary managed tablespace 4 GB * physical block size (with K/M modifier); 4 GB (without K/M modifier)
4 GB*物理塊大小（帶K/M修飾符）；4 GB（無K/M修改器）
Database extents Maximum per locally managed (uniform) tablespace 2 GB * physical block size (with K/M modifier); 2 GB (without K/M modifier)
2 GB*物理塊大小（帶K/M修飾符）；2 GB（無K/M修改器）
Database file size Maximum Operating system dependent. Limited by maximum operating system file size. See the Bigfile Tablespaces and Smallfile (traditional) Tablespaces rows for more information about the maximum database file size in these types of tablespaces.
取決於作業系統。受最大作業系統檔案大小限制。有關這些型別的表空間中最大資料庫檔案大小的更多資訊，請參閱Bigfile表空間和Smallfile（傳統）表空間行。
MAXEXTENTS Default value Derived from tablespace default storage or DB_BLOCK_SIZE initialization parameter
從表空間預設儲存或DB_BLOCK_SIZE初始化引數派生
MAXEXTENTS Maximum Unlimited
Redo Log Files Maximum number of logfiles Limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement
受CREATE DATABASE語句中MAXLOGFILES引數值的限制
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 File Size Minimum size 4 MB
Redo Log File Size Maximum Size Operating system limit; typically 2 TB
作業系統限制；通常為2 TB
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
表空間的數量不能超過資料庫檔案的數量，因為每個表空間必須至少包含一個檔案
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.
一個bigfile表空間只包含一個資料檔案或臨時檔案，它最多可以包含大約40億（2的32次方）個塊。對於具有32K塊的表空間，單個資料檔案或臨時檔案的最大大小為128 TB（TB），對於具有8K塊的資料空間，最大大小為32 TB。
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.
smallfile表空間是一個傳統的Oracle表空間，它可以包含1022個資料檔案或臨時檔案，每個檔案可以包含大約400萬（2的22次方）個塊。
External Tables file Maximum size Dependent on the operating system.
取決於作業系統。
An external table can be composed of multiple files.
外部表可以由多個檔案組成。


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29785807/viewspace-2928627/，如需轉載，請註明出處，否則將追究法律責任。

相關文章