Item | Type of Limit | Limit Value | 总结 |
Instances per database | Maximum number of cluster database instances per database | Operating system-dependent | Oracle中每个数据库的实例数量受限于操作系统 |
Locks | Row-level | Unlimited 无限制 | Oracle中最多可拥有行级锁的数量不受限制 |
Locks | Distributed Lock Manager | Operating system dependent 操作系统相关 | Oracle中分布式锁管理器最大数量与操作系统相关 |
SGA size | Maximum value | Operating system-dependent; typically 2 to 4 GB for 32-bit operating systems, and > 4 GB for 64-bit operating systems 操作系统相关 32位操作系统4G 64位可大于4G | Oracle中SGA最大大小与操作系统相关 如果是32位系统最多为4G,64位系统可大于4G |
Advanced Queuing Processes | Maximum per instance | 10 | Oracle中每个实例最多可以有10个高级队列进程 |
Job Queue Processes | Maximum per instance | 1000 | Oracle中每个实例最多可以有1000个任务队列进程 |
I/O Slave Processes | Maximum per background process (DBWR, LGWR, and so on) | 15 | Oracle中每个后台进程的IO从进程最多有15个 |
I/O Slave Processes | Maximum per Backup session | 15 | Oracle中每个备份会话 |
Sessions | Maximum per instance | 216; limited by the PROCESSES and SESSIONS initialization parameters. 216 is 65536. 65536; 受限于PROCESS 和 SESSIONS初始化参数 | Oracle中进程和会话数量的最大值受限于初始化参数 |
Global Cache Service Processes | Maximum per instance | 10 | Oracle中每个实例最多可以有10个GCS进程 (译者注:这里应该是文档不严谨) |
Shared Servers | Maximum per instance | Unlimited within constraints set by the PROCESSES and SESSIONS initialization parameters, for instance 无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 | Oracle中shared server数量无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 |
Dispatchers | Maximum per instance | Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance 无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 | Oracle中Dispatchers数量无限制 在设置PROCESSES和SESSIONS 初始化参数范围内 |
Parallel Execution Slaves | Maximum per instance | Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance 无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 | Oracle中并行执行从进程数量无限制 在设置PROCESSES和SESSIONS 初始化参数范围内 |
Backup Sessions | Maximum per instance | Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance 无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 | Oracle中备份会话数量无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 |
Services | Maximum per instance | 1024 | Oracle中每个实例服务最可可以有1024个 |