| 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.
外部表可以由多个文件组成。 |