Item | Type of Limit | Limit 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 |
Advanced Queuing Processes |
Maximum per instance |
|
Job Queue Processes |
Maximum per instance |
|
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 |
Global Cache Service Processes |
Maximum per instance |
|
Shared Servers |
Maximum per instance |
Unlimited within constraints set by the |
Dispatchers |
Maximum per instance |
Unlimited within constraints set by |
Parallel Execution Slaves |
Maximum per instance |
Unlimited within constraints set by |
Backup Sessions |
Maximum per instance |
Unlimited within constraints set by |
Services |
Maximum per instance |
1024 |