10.3.7 Increased Maximum Number of Database Processes
Minimum software required: 12.1.0.2 BP11, or 11.2.0.4 BP18
The following table shows the maximum number of database processes supported per database node. These numbers are higher than in previous releases. The best practice is to keep the process count below these values. If a subset of your workload is running parallel queries, the maximum database process count will be between the "Number of Processes with No Parallel Queries" column and the "Number of Processes with All Running Parallel Queries" column.
Table 10-3 Maximum Number of Database Processes Per Node
| Machine Type | InfiniBand Bonding Type | Maximum Number of Processes with No Parallel Queries | Maximum Number of Processes with All Running Parallel Queries |
|---|---|---|---|
|
8-socket (X2-8, X3-8) |
Active passive |
28,500 |
25,000 |
|
8-socket (X4-8, X5-8) |
Active bonding |
50,000 |
44,000 |
|
2-socket (X2-2, X3-2) |
Active passive |
12,500 |
10,000 |
|
2-socket (X4-2, X5-2) |
Active bonding |
16,500 |
14,000 |
The machines are configured as follows:
-
On an 8-socket database node with active bonding InfiniBand configurations (X4-8 and X5-8), there are 8 IP addresses across 4 InfiniBand cards (8 InfiniBand ports).
-
On an 8-socket database node with active-passive InfiniBand configurations (X2-8 and X3-8), there are 4 IP addresses across 4 InfiniBand cards (8 InfiniBand ports).
-
On a 2-socket database node with active bonding InfiniBand configurations (X4-2 and X5-2), there are 2 IP addresses on 1 InfiniBand card (2 InfiniBand ports).
-
On a 2-socket database node with active-passive InfiniBand configurations (X2-2 and X3-2), there is 1 IP address on 1 InfiniBand card (2 InfiniBand ports).
50,000 RDS sockets are provisioned per IP for database usage. Each IO-capable database process will consume RDS sockets across IPs with even load balancing.
Note that cells have the following connection limits:
-
On X4 and X5 systems, the cell connection limit is 120,000 processes.
-
On X2 and X3 systems, the cell connection limit is 60,000 processes.
This means that the total number of database processes cannot exceed the above limits on the cell nodes. For example, a full rack of 8 databases running at the maximum process count will exceed the cell connection limit.
Related Topics