|
Instances per database |
Maximum number of OPS instances per database |
Operating system dependent |
|
Locks |
Row-level |
Unlimited |
|
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 |
36 |
|
I/O Slave Processes |
Maximum per background process (DBWR, LGWR, etc.) |
15 |
|
Maximum per Backup session |
15 |
|
Sessions |
Maximum per instance |
32K; limited by the PROCESSES and SESSIONS initialization parameters. |
|
LCK Processes |
Maximum per instance |
10 |
|
MTS 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. |
