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 |