Previous Next JavaScript must be enabled to correctly display this content

## 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 X10-2S, X10-2L, and X10-2-HA.

The information in the table assumes the following:

- 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 X10-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 X10-L and X10-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 X10-2S, X10-2L, and X10-2-HA.

The information in the table assumes the following:

- 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 X10-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 X10-L and X10-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 X10-S, X10-L, and X10-HA.

The information in the table assumes the following:

- 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 X10-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 X10-L and X10-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