Database Sizing Templates
When you create a database using the dbcli create-database command, you can specify a database sizing template with the --dbshape parameter. The sizing templates are configured for different types of database workloads.
Choose the template that best matches the most common workload your database performs:
- Use the OLTP templates if your database workload is primarily online transaction processing (OLTP).
- Use the DSS templates if your database workload is primarily decision support (DSS) or data warehousing.
- Use the in-memory (IMDB) templates if your database workload can fit in memory, and can benefit from in-memory performance capabilities.
The following tables describe the templates for each type of workload.
OLTP Database Sizing Templates
| Template | CPU Cores | SGA (GB) | PGA (GB) | Flash (GB) | Processes | Redo Log File Size (GB) | Log Buffer (MB) |
|---|---|---|---|---|---|---|---|
| odb1s | 1 | 2 | 1 | 6 | 200 | 1 | 16 |
| odb1 | 1 | 4 | 2 | 12 | 200 | 1 | 16 |
| odb2 | 2 | 8 | 4 | 24 | 400 | 1 | 16 |
| odb4 | 4 | 16 | 8 | 48 | 800 | 1 | 32 |
| odb6 | 6 | 24 | 12 | 72 | 1200 | 2 | 64 |
| odb8 | 8 | 32 | 16 | n/a | 1600 | 2 | 64 |
| odb10 | 10 | 40 | 20 | n/a | 2000 | 2 | 64 |
| odb12 | 12 | 48 | 24 | 144 | 2400 | 4 | 64 |
| odb16 | 16 | 64 | 32 | 192 | 3200 | 4 | 64 |
| odb20 | 20 | 80 | 40 | n/a | 4000 | 4 | 64 |
| odb24 | 24 | 96 | 48 | 192 | 4800 | 4 | 64 |
| odb32 | 32 | 128 | 64 | 256 | 6400 | 4 | 64 |
| odb36 | 36 | 128 | 64 | 256 | 7200 | 4 | 64 |
DSS Database Sizing Templates
| Template | CPU Cores | SGA (GB) | PGA (GB) | Processes | Redo Log File Size (GB) | Log Buffer (MB) |
|---|---|---|---|---|---|---|
| odb1s | 1 | 1 | 2 | 200 | 1 | 16 |
| odb1 | 1 | 2 | 4 | 200 | 1 | 16 |
| odb2 | 2 | 4 | 8 | 400 | 1 | 16 |
| odb4 | 4 | 8 | 16 | 800 | 1 | 32 |
| odb6 | 6 | 12 | 24 | 1200 | 2 | 64 |
| odb8 | 8 | 16 | 32 | 1600 | 2 | 64 |
| odb10 | 10 | 20 | 40 | 2000 | 2 | 64 |
| odb12 | 12 | 24 | 48 | 2400 | 4 | 64 |
| odb16 | 16 | 32 | 64 | 3200 | 4 | 64 |
| odb20 | 20 | 40 | 80 | 4000 | 4 | 64 |
| odb24 | 24 | 48 | 96 | 4800 | 4 | 64 |
| odb32 | 32 | 64 | 128 | 6400 | 4 | 64 |
| odb36 | 36 | 64 | 128 | 7200 | 4 | 64 |
In-Memory Database Sizing Templates
| Template | CPU Cores | SGA (GB) | PGA (GB) | In-Memory (GB) | Processes | Redo Log Lile Size (GB) | Log Buffer (MB) |
|---|---|---|---|---|---|---|---|
| odb1s | 1 | 2 | 1 | 1 | 200 | 1 | 16 |
| odb1 | 1 | 4 | 2 | 2 | 200 | 1 | 16 |
| odb2 | 2 | 8 | 4 | 4 | 400 | 1 | 16 |
| odb4 | 4 | 16 | 8 | 8 | 800 | 1 | 32 |
| odb6 | 6 | 24 | 12 | 12 | 1200 | 2 | 64 |
| odb8 | 8 | 32 | 16 | 16 | 1600 | 2 | 64 |
| odb10 | 10 | 40 | 20 | 20 | 2000 | 2 | 64 |
| odb12 | 12 | 48 | 24 | 24 | 2400 | 4 | 64 |
| odb16 | 16 | 64 | 32 | 32 | 3200 | 4 | 64 |
| odb20 | 20 | 80 | 40 | 40 | 4000 | 4 | 64 |
| odb24 | 24 | 96 | 48 | 48 | 4800 | 4 | 64 |
| odb32 | 32 | 128 | 64 | 64 | 6400 | 4 | 64 |
| odb36 | 36 | 128 | 64 | 64 | 7200 | 4 | 64 |