Use the information in this appendix to select database templates for your planned databases. Oracle strongly recommends that you use the Oracle Database Appliance templates, because they implement best practices and are configured specifically for Oracle Database Appliance.
The templates not only define databases with parameters that have been selected specifically to optimize performance on Oracle Database Appliance but also help you to set up appropriate instance caging, to create ODA_BASE with a matching template on Oracle Database Appliance Virtualized Platform, and to acquire an appropriate license on bare metal installations.
Tip:
Oracle Appliance Manager configurator refers to the database sizing templates as classes of databases.With its multiple CPUs, Oracle Database Appliance enables you to consolidate many databases onto 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 the desired levels of service across multiple instances on a single Oracle Database Appliance.
Oracle Database Appliance templates are already tuned for the size of each database instance workload. They are designed to run on a specific number of cores. Caging assures that each database workload is restricted to the set of cores allocated by the template, enabling multiple databases to run concurrently with no performance degradation, up to the capacity of Oracle Database Appliance. You could select database template 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 templates, because they implement best practices and are configured specifically for Oracle Database Appliance.Use the following tables to help select the best templates for your databases. When using these tables remember:
The information in the tables assume that you are creating disk backups. The information in the tables assume that you are creating local disk backups. Consider the space requirements for your database and the policy for local disk backups vs external backups. With external backups, there is more space available for the database versus the local backups where backups are stored locally.
Container databases are created on Oracle ACFS and the following tables show the amount space taken in the ACFS file system. Note that an Oracle ACFS file system can be extended to avoid running out of space.
I/O per second (IOps) values are derived from an 8 K random read-write response time of 10-12 milliseconds for HDDs, and less than 1 millisecond for Flash, for Oracle Database Appliance X5-2; 5-7 milliseconds for Oracle Database Appliance X4-2 and X3-2; and 5 milliseconds for Oracle Database Appliance Version 1 to service an online transaction processing (OLTP) I/O request. The rates are not based on the number of CPUs and assume that the system is running at capacity.
Throughput, in MB per second (MBps). is based on a 1 MB sequential read/write for a data warehousing system. As with IOps, the MBps is a measure of throughput when the system is at capacity. With just a single small database running, the MBps would be the maximum available on the system for a large database.
The log file size assumes four redo log groups for each instance with a log switch every 15 minutes when the system is running at full capacity.
Find the information that is appropriate to your database workload and hardware:
Use Table B-2 if your database workload is of type OLTP
Use Table B-3 if your database workload is of type DSS (Data Warehouse)
Use Table B-4 if your database workload is of type In-Memory
Use Table B-5 if your database is on Oracle Database Appliance X5-2
Use Table B-6 if your database is on Oracle Database Appliance X4-2
Use Table B-7 if your database is on Oracle Database Appliance X3-2
Use Table B-8 if your database is on original model of Oracle Database Appliance.
Note:
Oracle Appliance Manager Release 12.1.2.2.0 provides improved database templates that are specific to the type of database workload (OLTP, DSS, In-Memory) rather than the generic templates that were used in the earlier releases. The database sizing tables provide updated template names and sizing based on the number of CPUs and memory attributes for each type of database workload. Table B-1 provides a reference between the generic database template names and the database template names based on CPU cores.Table B-1 Oracle Database Appliance Database Template Name Conversions
CPU Core-Based Database Template Names | odb-01s | odb-01 | odb-02 | odb-04 | odb-06 | odb-12 | odb-16 | odb-24 |
---|---|---|---|---|---|---|---|---|
Generic Database Template Names |
Very Very Small |
Very Small |
Small |
Medium |
Large |
Extra Large |
Extra Extra LargeFootref 1 |
Extra Extra Extra LargeFoot 1 |
Footnote 1 Extra Extra Large is applicable to Oracle Database Appliance X3-2 and Oracle Database Appliance X4-2. Extra Extra Extra Large is applicable to Oracle Database Appliance X4-2 only.
Table B-2 Oracle Database Appliance OLTP Database Template Size
Template | CPU Cores | SGA (GB) | PGA (GB) | Flash (GB) | Processes | Redo log file size (GB) | Logbuffer (MB) |
---|---|---|---|---|---|---|---|
odb-01s (All Hardware Versions) |
1 |
2 |
1 |
6 |
200 |
1 |
16 |
odb-01 (All Hardware Versions) |
1 |
4 |
2 |
12 |
200 |
1 |
16 |
odb-02 (All Hardware Versions) |
2 |
8 |
4 |
24 |
400 |
1 |
16 |
odb-04 (All Hardware Versions) |
4 |
16 |
8 |
48 |
800 |
1 |
32 |
odb-06 (All Hardware Versions) |
6 |
24 |
12 |
72 |
1200 |
2 |
64 |
odb-12 (All Hardware Versions) |
12 |
48 |
24 |
144 |
2400 |
4 |
64 |
odb-16 (X5-2, X4-2, X3-2 Only) |
16 |
64 |
32 |
192 |
3200 |
4 |
64 |
odb-24 (X5-2, X4-2 Only) |
24 |
96 |
48 |
192 |
4800 |
4 |
64 |
odb-32 (X5-2 Only) |
32 |
128 |
64 |
192 |
6400 |
4 |
64 |
odb-36 (X5-2 Only) |
36 |
128 |
64 |
192 |
7200 |
4 |
64 |
Note:
Flash is applicable to Oracle Database Appliance X5-2 only.Table B-3 Oracle Database Appliance DSS Database Template Size
Template | CPU Cores | SGA (GB) | PGA (GB) | Processes | Redo log file size (GB) | Logbuffer (MB) |
---|---|---|---|---|---|---|
odb-01s (All Hardware Versions) |
1 |
1 |
2 |
200 |
1 |
16 |
odb-01 (All Hardware Versions) |
1 |
2 |
4 |
200 |
1 |
16 |
odb-02 (All Hardware Versions) |
2 |
4 |
8 |
400 |
1 |
16 |
odb-04 (All Hardware Versions) |
4 |
8 |
16 |
800 |
1 |
32 |
odb-06 (All Hardware Versions) |
6 |
12 |
24 |
1200 |
2 |
64 |
odb-12 (All Hardware Versions) |
12 |
24 |
48 |
2400 |
4 |
64 |
odb-16 (X5-2, X4-2, X3-2 Only) |
16 |
32 |
64 |
3200 |
4 |
64 |
odb-24 (X5-2, X4-2 Only) |
24 |
48 |
96 |
4800 |
4 |
64 |
odb-32 (X5-2 Only) |
32 |
64 |
128 |
6400 |
4 |
64 |
odb-36 (X5-2 Only) |
36 |
64 |
128 |
7200 |
4 |
64 |
Table B-4 Oracle Database Appliance In-Memory Database Template Size
Template | CPU Cores | SGA (GB) | PGA (GB) | In-Memory (GB) | Processes | Redo log file size (GB) | Logbuffer (MB) |
---|---|---|---|---|---|---|---|
odb-01s (All Hardware Versions) |
1 |
2 |
1 |
1 |
200 |
1 |
16 |
odb-01 (All Hardware Versions) |
1 |
4 |
2 |
2 |
200 |
1 |
16 |
odb-02 (All Hardware Versions) |
2 |
8 |
4 |
4 |
400 |
1 |
16 |
odb-04 (All Hardware Versions) |
4 |
16 |
8 |
8 |
800 |
1 |
32 |
odb-06 (All Hardware Versions) |
6 |
24 |
12 |
12 |
1200 |
2 |
64 |
odb-12 (All Hardware Versions) |
12 |
48 |
24 |
24 |
2400 |
4 |
64 |
odb-16 (X5-2, X4-2, X3-2 Only) |
16 |
64 |
32 |
32 |
3200 |
4 |
64 |
odb-24 (X5-2, X4-2 Only) |
24 |
96 |
48 |
48 |
4800 |
4 |
64 |
odb-32 (X5-2 Only) |
32 |
128 |
64 |
64 |
6400 |
4 |
64 |
odb-36 (X5-2 Only) |
36 |
128 |
64 |
64 |
7200 |
4 |
64 |
Table B-5 Oracle Database Appliance X5-2 Database Template Size Storage Performance
Template | Number of databases using this template that you can deploy | Container Database ACFS Size on DATA Diskgroup (GB) | I/O per second with single storage shelf (HDD/FLASH) | Throughput (MB/second) with single storage shelf (HDD/FLASH) | I/O per second with storage shelf plus storage expansion shelf (HDD/FLASH) | Throughput (MB/second) with storage shelf plus storage expansion shelf (HDD/FLASH) | Log generation (MB/second) |
---|---|---|---|---|---|---|---|
odb-01s |
36 |
100 |
42/4167 |
83/83 |
83/8333 |
167/167 |
6.83 |
odb-01 |
36 |
100 |
42/4167 |
83/83 |
83/8333 |
167/167 |
6.83 |
odb-02 |
18 |
200 |
83/8.3K |
167/167 |
167/16.7K |
333/333 |
6.83 |
odb-04 |
9 |
400 |
167/16.7K |
333/333 |
333/33.3K |
667/667 |
13.65 |
odb-06 |
6 |
800 |
250/25K |
500/500 |
500/50K |
1000/1000 |
27.3 |
odb-12 |
3 |
1600 |
500/50K |
1000/1000 |
1000/100K |
2000/2000 |
27.3 |
odb-16 |
2 |
1600 |
750/75K |
1500/1500 |
1500/150K |
3000/3000 |
27.3 |
odb-24 |
1 |
1600 |
1500/150K |
3000/3000 |
3000/300K |
6000/6000 |
27.3 |
odb-32 |
1 |
1600 |
1500/150K |
3000/3000 |
3000/300K |
6000/6000 |
27.3 |
odb-36 |
1 |
1600 |
1500/150K |
3000/3000 |
3000/300K |
6000/6000 |
27.3 |
Note:
Actual IOps and throughput for a given database will depend on the percentage of I/O operations that are serviced through the FLASH versus the HDDs. An OLTP workload whose working set fits in FLASH will be 80% reads (serviced through the flash cache) and 20% writes (serviced through the HDDs). Thus, the actual IO performance will be weighted appropriately.Table B-6 Oracle Database Appliance X4-2 Database Template Size Storage Performance
Template | Number of databases using this template that you can deploy | Container Database ACFS Size on DATA Diskgroup (GB) | I/O per second with single storage shelf | Throughput (MB/second) with single storage shelf | I/O per second with storage shelf plus storage expansion shelf | Throughput (MB/second) with storage shelf plus storage expansion shelf | Log generation (MB/second) |
---|---|---|---|---|---|---|---|
odb-01s |
24 |
100 |
138 |
146 |
275 |
229 |
6.83 |
odb-01 |
24 |
100 |
138 |
146 |
275 |
230 |
6.83 |
odb-02 |
12 |
200 |
275 |
292 |
550 |
458 |
6.83 |
odb-04 |
6 |
400 |
550 |
583 |
1100 |
917 |
13.65 |
odb-06 |
4 |
800 |
825 |
875 |
1650 |
1375 |
27.3 |
odb-12 |
2 |
1600 |
1650 |
1750 |
3300 |
2750 |
27.3 |
odb-16 |
1 |
1600 |
3300 |
3500 |
6600 |
5500 |
27.3 |
odb-24 |
1 |
1600 |
3300 |
3500 |
6600 |
5500 |
27.3 |
Table B-7 Oracle Database Appliance X3-2 Database Template Size Storage Performance
Template | Number of databases using this template that you can deploy | Container Database ACFS Size on DATA Diskgroup (GB) | I/O per second with single storage shelf | Throughput (MB/second) with single storage shelf | I/O per second with storage shelf plus storage expansion shelf | Throughput (MB/second) with storage shelf plus storage expansion shelf | Log generation (MB/second) |
---|---|---|---|---|---|---|---|
odb-01s |
16 |
100 |
206 |
219 |
413 |
344 |
6.83 |
odb-01 |
16 |
100 |
206 |
219 |
413 |
344 |
6.83 |
odb-02 |
8 |
200 |
413 |
438 |
825 |
688 |
6.83 |
odb-04 |
4 |
400 |
825 |
875 |
1650 |
1375 |
13.65 |
odb-06 |
2 |
800 |
1650 |
1750 |
3300 |
2750 |
27.3 |
odb-12 |
1 |
1600 |
3300 |
3500 |
6600 |
5500 |
27.3 |
odb-16 |
1 |
1600 |
3300 |
3500 |
6600 |
5500 |
27.3 |
Table B-8 Oracle Database Appliance Version 1 Database Template Size Storage Performance
Template | Number of databases using this template that you can deploy | Container Database ACFS Size on DATA Diskgroup (GB) | I/O per second | Throughput (MB/second) | Log generation (MB/second) |
---|---|---|---|---|---|
odb-01s |
12 |
100 |
333 |
250 |
6.83 |
odb-01 |
12 |
100 |
333 |
250 |
6.83 |
odb-02 |
6 |
200 |
667 |
500 |
6.83 |
odb-04 |
3 |
400 |
1333 |
1000 |
13.65 |
odb-06 |
2 |
800 |
2000 |
1500 |
27.3 |
odb-12 |
1 |
1600 |
4000 |
3000 |
27.3 |
For a single database, select a template that best fits your expected workload on the hardware you are using in terms of required CPU and IOps. When creating multiple databases, the overall workload will be affected by the CPU and IOps consumed by the existing databases that are already on the system.