반응형
Process and Runtime Limits
Process and Runtime Limits
This table describes limit types and limit values for process and runtime items.
ItemType of LimitLimit Value
| Instances per database | Maximum number of cluster database instances per database | Operating system-dependent |
| Locks | Row-level | Unlimited |
| Locks | Distributed Lock Manager | Operating system dependent |
| 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 |
| Advanced Queuing Processes | Maximum per instance | 10 |
| Job Queue Processes | Maximum per instance | 1000 |
| I/O Slave Processes | Maximum per background process (DBWR, LGWR, and so on) | 15 |
| I/O Slave Processes | Maximum per Backup session | 15 |
| Sessions | Maximum per instance | 216; limited by the PROCESSES and SESSIONS initialization parameters. 216 is 65536. |
| Global Cache Service Processes | Maximum per instance | 10 |
| Shared Servers | Maximum per instance | Unlimited within constraints set by the PROCESSES and SESSIONS initialization parameters, for instance |
| Dispatchers | Maximum per instance | Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance |
| Parallel Execution Slaves | Maximum per instance | Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance |
| Backup Sessions | Maximum per instance | Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance |
| Services | Maximum per instance | 8200 |
반응형
'ORACLE > 19C' 카테고리의 다른 글
| Logical Database Limits(논리적 데이터베이스 제한) (0) | 2024.02.14 |
|---|---|
| Physical Database Limits(물리적 데이터베이스 제한) (0) | 2024.02.14 |
| Datatype Limits(데이터 유형 제한) (0) | 2024.02.14 |
