D Database Shapes for Oracle Database Appliance
Use the information in this appendix to select database shapes, or templates, for your planned databases.
- About Database Shapes and Classes
Review this information to help determine the database shape (also known as a database template) and class to use based on the common workload your databases perform. - Database Shapes for the OLTP Class
Use Oracle Database Appliance OLTP Database Shapes if your database workload is primarily online transaction processing (OLTP). - Database Shapes for the In-Memory Class
Use Oracle Database Appliance In-Memory (IMDB) database shapes if your database workload can fit in memory, and can benefit from in-memory performance capabilities. - Database Shapes for the DSS Class
Use DSS database shapes if your database workload is primarily decision support services (DSS) or data warehousing.
About Database Shapes and Classes
Review this information to help determine the database shape (also known as a database template) and class to use based on the common workload your databases perform.
Oracle Database Appliance shapes define databases with parameters selected specifically to optimize performance on Oracle Database Appliance. In addition, these shapes help you to set up appropriate instance caging.
Oracle Database Appliance enables you to consolidate many databases into a single system. Consolidation can minimize idle resources, maximize efficiency, and lower costs. By using instance caging in conjunction with Oracle Database Resource Manager (the Resource Manager), you can provide desired levels of service across multiple instances on a single Oracle Database Appliance.
Oracle Database Appliance shapes are already tuned for the size of each database instance workload. They are designed to run on a specific number of cores. Caging ensures that each database workload is restricted to the set of cores allocated by the shape, enabling multiple databases to run concurrently with no performance degradation, up to the capacity of Oracle Database Appliance. You can select database shape sizes larger than your current needs to provide for planned growth, which you accommodate later by adjusting System Global Area (SGA) and Program Global Area (PGA) sizes as well as the number of cores.
Note:
Oracle strongly recommends that you use the Oracle Database Appliance shapes, because they implement best practices and are configured specifically for Oracle Database Appliance.
Important:
Except for the largest database shape, all other database shapes supported on the Oracle Database Appliance bare metal system are also supported on Oracle Database Appliance DB system.
Choosing a Database Shape
Database shapes are configured specifically for the type of database workload that you want to carry out on your databases on Oracle Database Appliance. Choose the shape that best matches the common workload your databases perform (OLTP, DSS, In-Memory).
The database sizing tables provide shape names and sizing based on the number of CPUs and memory attributes for each type of database workload.
Identify the shape type that is appropriate to your database workload and hardware:
-
Use Oracle Database Appliance OLTP Database Shapes if your database workload is primarily online transaction processing (OLTP).
-
Use Oracle Database Appliance DSS database shapes if your database workload is primarily decision support services (DSS) or data warehousing.
-
Use Oracle Database Appliance In-Memory (IMDB) database shapes if your database workload can fit in memory, and can benefit from in-memory performance capabilities.
Use the database shape tables to help select the best shapes for your databases. When using these tables remember the following:
-
The information in the tables assumes that you are creating local disk backups. Consider the space requirements for your database and the policy for local disk backups versus external backups. Typically, external backups have more space available for the database than local backups.
-
The log file size assumes three (3) REDO log groups for each instance with a log switch every 15 minutes when the system is running at full capacity.
Parent topic: Database Shapes for Oracle Database Appliance
Database Shapes for the OLTP Class
Use Oracle Database Appliance OLTP Database Shapes if your database workload is primarily online transaction processing (OLTP).
The tables list the online transaction processing (OLTP) database shape sizes for Oracle Database Appliance X11-S, X11-L, and X11-HA.
-
You are creating local disk backups. Consider the space requirements for your database and the policy for local disk backups versus external backups. Typically, external backups have more space available for the database than local backups.
Table D-1 Oracle Database Appliance X11-S OLTP Database Shapes
| Shape | CPU Cores | SGA (GB) | PGA (GB) | Processes | Redo log file size (GB) | Log buffer (MB) |
|---|---|---|---|---|---|---|
|
odb1s |
1 |
2 |
1 |
200 |
4 |
32 |
|
odb1 |
1 |
4 |
2 |
200 |
4 |
32 |
|
odb2 |
2 |
8 |
4 |
400 |
4 |
32 |
|
odb4 |
4 |
16 |
8 |
800 |
4 |
64 |
|
odb6 |
6 |
24 |
12 |
1200 |
8 |
256 |
|
odb08 |
8 |
32 |
16 |
1600 |
8 |
256 |
|
odb10 |
10 |
40 |
20 |
2000 |
8 |
256 |
|
odb12 |
12 |
48 |
24 |
2400 |
16 |
256 |
|
odb16 |
16 |
64 |
32 |
3200 |
16 |
256 |
|
odb20 |
20 |
80 |
40 |
4000 |
16 |
256 |
|
odb24 |
24 |
96 |
48 |
4800 |
16 |
256 |
|
odb28 |
28 |
112 |
56 |
5600 |
16 |
256 |
|
odb32 |
32 |
128 |
64 |
6400 |
16 |
256 |
Table D-2 Oracle Database Appliance X11-L and X11-HA OLTP Database Shapes
| Shape | CPU Cores | SGA (GB) | PGA (GB) | Processes | Redo log file size (GB) | Log buffer (MB) |
|---|---|---|---|---|---|---|
|
odb1s |
1 |
2 |
1 |
200 |
4 |
32 |
|
odb1 |
1 |
4 |
2 |
200 |
4 |
32 |
|
odb2 |
2 |
8 |
4 |
400 |
4 |
32 |
|
odb4 |
4 |
16 |
8 |
800 |
4 |
64 |
|
odb6 |
6 |
24 |
12 |
1200 |
8 |
256 |
|
odb08 |
8 |
32 |
16 |
1600 |
8 |
256 |
|
odb10 |
10 |
40 |
20 |
2000 |
8 |
256 |
|
odb12 |
12 |
48 |
24 |
2400 |
16 |
256 |
|
odb16 |
16 |
64 |
32 |
3200 |
16 |
256 |
|
odb20 |
20 |
80 |
40 |
4000 |
16 |
256 |
|
odb24 |
24 |
96 |
48 |
4800 |
16 |
256 |
|
odb28 |
28 |
112 |
56 |
5600 |
16 |
256 |
|
odb32 |
32 |
128 |
64 |
6400 |
16 |
256 |
|
odb36 |
36 |
144 |
72 |
7200 |
32 |
256 |
|
odb42 |
42 |
168 |
84 |
8400 |
32 |
256 |
|
odb48 |
48 |
192 |
96 |
9600 |
32 |
256 |
|
odb56 |
56 |
224 |
112 |
11200 |
32 |
256 |
|
odb64 |
64 |
256 |
128 |
12800 |
32 |
256 |
Parent topic: Database Shapes for Oracle Database Appliance
Database Shapes for the In-Memory Class
Use Oracle Database Appliance In-Memory (IMDB) database shapes if your database workload can fit in memory, and can benefit from in-memory performance capabilities.
The tables list the In-Memory database shape sizes for Oracle Database Appliance X11-2S, X11-2L, and X11-2-HA.
-
You are creating local disk backups. Consider the space requirements for your database and the policy for local disk backups versus external backups. Typically, external backups have more space available for the database than local backups.
Table D-3 Oracle Database Appliance X11-S In-Memory Database Shapes
| Shape | CPU Cores | SGA (GB) | PGA (GB) | In-Memory | Processes | Redo log file size (GB) | Log buffer (MB) |
|---|---|---|---|---|---|---|---|
|
odb1s |
1 |
2 |
1 |
1 |
200 |
4 |
32 |
|
odb1 |
1 |
4 |
2 |
2 |
200 |
4 |
32 |
|
odb2 |
2 |
8 |
4 |
4 |
400 |
4 |
32 |
|
odb4 |
4 |
16 |
8 |
8 |
800 |
4 |
64 |
|
odb6 |
6 |
24 |
12 |
12 |
1200 |
8 |
256 |
|
odb08 |
8 |
32 |
16 |
16 |
1600 |
8 |
256 |
|
odb10 |
10 |
40 |
20 |
20 |
2000 |
8 |
256 |
|
odb12 |
12 |
48 |
24 |
24 |
2400 |
16 |
256 |
|
odb16 |
16 |
64 |
32 |
32 |
3200 |
16 |
256 |
|
odb20 |
20 |
80 |
40 |
42 |
4000 |
16 |
256 |
|
odb24 |
24 |
96 |
48 |
48 |
4800 |
16 |
256 |
|
odb28 |
28 |
112 |
56 |
56 |
5600 |
16 |
256 |
|
odb32 |
32 |
128 |
64 |
64 |
6400 |
16 |
256 |
Table D-4 Oracle Database Appliance X11-L and X11-HA In-Memory Database Shapes
| Shape | CPU Cores | SGA (GB) | PGA (GB) | In-Memory | Processes | Redo log file size (GB) | Log buffer (MB) |
|---|---|---|---|---|---|---|---|
|
odb1s |
1 |
2 |
1 |
1 |
200 |
4 |
32 |
|
odb1 |
1 |
4 |
2 |
2 |
200 |
4 |
32 |
|
odb2 |
2 |
8 |
4 |
4 |
400 |
4 |
32 |
|
odb4 |
4 |
16 |
8 |
8 |
800 |
4 |
64 |
|
odb6 |
6 |
24 |
12 |
12 |
1200 |
8 |
256 |
|
odb08 |
8 |
32 |
16 |
16 |
1600 |
8 |
256 |
|
odb10 |
10 |
40 |
20 |
20 |
2000 |
8 |
256 |
|
odb12 |
12 |
48 |
24 |
24 |
2400 |
16 |
256 |
|
odb16 |
16 |
64 |
32 |
32 |
3200 |
16 |
256 |
|
odb20 |
20 |
80 |
40 |
42 |
4000 |
16 |
256 |
|
odb24 |
24 |
96 |
48 |
48 |
4800 |
16 |
256 |
|
odb28 |
28 |
112 |
56 |
56 |
5600 |
16 |
256 |
|
odb32 |
32 |
128 |
64 |
64 |
6400 |
16 |
256 |
|
odb36 |
36 |
144 |
72 |
72 |
7200 |
32 |
256 |
|
odb42 |
42 |
168 |
84 |
84 |
8400 |
32 |
256 |
|
odb48 |
48 |
192 |
96 |
96 |
9600 |
32 |
256 |
|
odb56 |
56 |
224 |
112 |
112 |
11200 |
32 |
256 |
|
odb64 |
64 |
256 |
128 |
128 |
12800 |
32 |
256 |
Parent topic: Database Shapes for Oracle Database Appliance
Database Shapes for the DSS Class
Use DSS database shapes if your database workload is primarily decision support services (DSS) or data warehousing.
The tables list the DSS database shape sizes for Oracle Database Appliance X11-S, X11-L, and X11-HA.
-
You are creating local disk backups. Consider the space requirements for your database and the policy for local disk backups versus external backups. Typically, external backups have more space available for the database than local backups.
Table D-5 Oracle Database Appliance X11-S DSS Database Shapes
| Shape | CPU Cores | SGA (GB) | PGA (GB) | Processes | Redo log file size (GB) | Log buffer (MB) |
|---|---|---|---|---|---|---|
|
odb1s |
1 |
1 |
2 |
200 |
4 |
32 |
|
odb1 |
1 |
2 |
4 |
200 |
4 |
32 |
|
odb2 |
2 |
4 |
8 |
400 |
4 |
32 |
|
odb4 |
4 |
8 |
16 |
800 |
4 |
64 |
|
odb6 |
6 |
12 |
24 |
1200 |
8 |
256 |
|
odb08 |
8 |
16 |
32 |
1600 |
8 |
256 |
|
odb10 |
10 |
20 |
40 |
2000 |
8 |
256 |
|
odb12 |
12 |
24 |
48 |
2400 |
16 |
256 |
|
odb16 |
16 |
32 |
64 |
3200 |
16 |
256 |
|
odb20 |
20 |
40 |
80 |
4000 |
16 |
256 |
|
odb24 |
24 |
48 |
96 |
4800 |
16 |
256 |
|
odb28 |
28 |
56 |
112 |
5600 |
16 |
256 |
|
odb32 |
32 |
64 |
128 |
6400 |
16 |
256 |
Table D-6 Oracle Database Appliance X11-L and X11-HA DSS Database Shapes
| Shape | CPU Cores | SGA (GB) | PGA (GB) | Processes | Redo log file size (GB) | Log buffer (MB) |
|---|---|---|---|---|---|---|
|
odb1s |
1 |
1 |
2 |
200 |
4 |
32 |
|
odb1 |
1 |
2 |
4 |
200 |
4 |
32 |
|
odb2 |
2 |
4 |
8 |
400 |
4 |
32 |
|
odb4 |
4 |
8 |
16 |
800 |
4 |
64 |
|
odb6 |
6 |
12 |
24 |
1200 |
8 |
256 |
|
odb08 |
8 |
16 |
32 |
1600 |
8 |
256 |
|
odb10 |
10 |
20 |
40 |
2000 |
8 |
256 |
|
odb12 |
12 |
24 |
48 |
2400 |
16 |
256 |
|
odb16 |
16 |
32 |
64 |
3200 |
16 |
256 |
|
odb20 |
20 |
40 |
80 |
4000 |
16 |
256 |
|
odb24 |
24 |
48 |
96 |
4800 |
16 |
256 |
|
odb28 |
28 |
56 |
112 |
5600 |
16 |
256 |
|
odb32 |
32 |
64 |
128 |
6400 |
16 |
256 |
|
odb36 |
36 |
72 |
144 |
7200 |
32 |
256 |
|
odb42 |
42 |
84 |
168 |
8400 |
32 |
256 |
|
odb48 |
48 |
96 |
192 |
9600 |
32 |
256 |
|
odb56 |
56 |
112 |
224 |
11200 |
32 |
256 |
|
odb64 |
64 |
128 |
256 |
12800 |
32 |
256 |
Parent topic: Database Shapes for Oracle Database Appliance