相关链接
·listagg函数 ORA-01489: result
·Oracle 序列详解与12C新特性
·使用10053trace 揭秘 Oracle 12C
·Oracle分页写法大全
·Oracle进程和运行时限制

Oracle进程和运行时限制

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

OracleSGA最大大小与操作系统相关
如果是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中每个实例最多可以有10GCS进程

(译者注:这里应该是文档不严谨)

Shared Servers

Maximum per instance

Unlimited within constraints set by the PROCESSES and SESSIONS initialization parameters, for instance
无限制,在设置PROCESSESSESSIONS 初始化参数范围内

Oracleshared server数量无限制,在设置PROCESSESSESSIONS 初始化参数范围内

Dispatchers

Maximum per instance

Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance
无限制,在设置PROCESSESSESSIONS 初始化参数范围内

OracleDispatchers数量无限制
在设置PROCESSESSESSIONS 初始化参数范围内

Parallel Execution Slaves

Maximum per instance

Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance
无限制,在设置PROCESSESSESSIONS 初始化参数范围内

Oracle中并行执行从进程数量无限制
在设置PROCESSESSESSIONS 初始化参数范围内

Backup Sessions

Maximum per instance

Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance
无限制,在设置PROCESSESSESSIONS 初始化参数范围内

Oracle中备份会话数量无限制,在设置PROCESSESSESSIONS 初始化参数范围内

Services

Maximum per instance

1024

Oracle中每个实例服务最可可以有1024

上一篇:Oracle分页写法大全|下一篇:Oracle逻辑数据库限制

微信扫一扫
获取大数据学习资料