Use the information in this appendix to select database templates for your planned databases.
Topics:
Review this information to help determine the database template to use.
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 templates 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 template, enabling multiple databases to run concurrently with no performance degradation, up to the capacity of Oracle Database Appliance. You can 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.
The Oracle Appliance Manager Configurator refers to the database sizing templates as classes of databases.
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 database sizing tables to help select the best templates for your databases. When using the sizing tables remember that:
The information in the tables assumes 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 versus external backups. Typically, external backups have more space available for the database than local backups.
Container databases are created on Oracle ACFS.
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.
Storage is shared between the servers on Oracle Database Appliance.
About Oracle Database Appliance Template Options
The database templates are configured specifically for the type of database workload that you want to carry out on your databases on Oracle Database Appliance. Choose the template that best matches the common workload your databases perform (OLTP, DSS, In-Memory).
The database sizing tables provide template names and sizing based on the number of CPUs and memory attributes for each type of database workload.
Identify the template type that is appropriate to your database workload and hardware:
Use Oracle Database Appliance OLTP Database Templates if your database workload is primarily online transaction processing (OLTP).
Use Oracle Database Appliance DSS database templates if your database workload is primarily decision support services (DSS) or data warehousing.
Use Oracle Database Appliance In-Memory (IMDB) database templates if your database workload can fit in memory, and can benefit from in-memory performance capabilities.
Use the platform-specific database templates if your database is on a specific platform. For example, use Oracle Database Appliance X6-2-HA generic database templates if your database is on Oracle Database Appliance X6-2-HA.
The templates provide general guidelines about the maximum number of databases on a fully deployed Oracle Database Appliance. Base the memory and CPU sizing on the number of instances per server, not the number of databases. Memory and CPUs are shared by all databases and the number of databases impacts performance. For example, when you have one database, the database receives full I/O throughput. If you have 9 databases, then each database has only 1/9th of the available I/O throughput for all disks.
When you have multiple databases, they share and compete over available CPU resources. When choosing a template, do not have more CPU_COUNTs distributed than available threads in the system. Oracle recommends partitioning, where every database has exclusive CPUs. If you choose to exceed the recommended maximum number of databases on Oracle Database Appliance (over-provision), be aware of your I/O results and performance degradation. With the over-provisioned approach, the sum of the CPU_COUNT across all instances can exceed the number of CPUs. Better resource utilization is provided with over-provisioning; however, it is possible for contention to occur when multiple databases are heavily loaded at the same time. Over-provisioning is best used for systems running non-critical applications. Avoid using over-provisioning for databases with high I/O requirements or those with high transaction rates. If you choose to over-provision, then do not exceed twice the number of total CPUs. Twice the allocation of total CPUs is based on hyper-threading of 2 CPU threads per core.
Use one of the database templates defined for Oracle Database Appliance X6-2-HA.
Oracle Database Appliance OLTP Database Template Sizes
Table C-1 Oracle Database Appliance OLTP Database Template Sizes
| Template | CPU Cores | SGA (GB) | PGA (GB) | Flash | Processes | LOG buffer, Redo Log |
|---|---|---|---|---|---|---|
|
odb-01s |
1 |
2 |
1 |
6 |
200 |
16 MB, 1 GB |
|
odb-01 |
1 |
4 |
2 |
12 |
200 |
16 MB, 1 GB |
|
odb-02 |
2 |
8 |
4 |
24 |
400 |
16 MB, 1 GB |
|
odb-04 |
4 |
16 |
8 |
48 |
800 |
32 MB, 1 GB |
|
odb-06 |
6 |
24 |
12 |
72 |
1200 |
64 MB, 2 GB |
|
odb-12 |
12 |
48 |
24 |
144 |
2400 |
64 MB, 4 GB |
|
odb-16 |
16 |
64 |
32 |
192 |
3200 |
64 MB, 4 GB |
|
odb-20 |
20 |
80 |
40 |
NA |
4000 |
64 MB, 4 GB |
Oracle Database Appliance DSS Database Template Sizes
Table C-2 Oracle Database Appliance DSS Database Template Sizes
| Template | CPU Cores | SGA (GB) | PGA (GB) | Processes | Redo log file size (GB) | Log buffer (MB) |
|---|---|---|---|---|---|---|
|
odb-01s |
1 |
1 |
2 |
200 |
1 |
16 |
|
odb-01 |
1 |
2 |
4 |
200 |
1 |
16 |
|
odb-02 |
2 |
4 |
8 |
400 |
1 |
16 |
|
odb-04 |
4 |
8 |
16 |
800 |
1 |
32 |
|
odb-06 |
6 |
12 |
24 |
1200 |
2 |
64 |
|
odb-12 |
12 |
24 |
48 |
2400 |
4 |
64 |
|
odb-16 |
16 |
32 |
64 |
3200 |
4 |
64 |
|
odb-20 |
20 |
40 |
80 |
4000 |
4 |
64 |
Oracle Database Appliance In-Memory Database Template Size
Table C-3 Oracle Database Appliance In-Memory Database Template Size
| Template | CPU Cores | SGA (GB) | PGA (GB) | In-Memory (GB) | Processes | Redo log file size (GB) | Log buffer (MB) |
|---|---|---|---|---|---|---|---|
|
odb-01s |
1 |
2 |
1 |
1 |
200 |
1 |
16 |
|
odb-01 |
1 |
4 |
2 |
2 |
200 |
1 |
16 |
|
odb-02 |
2 |
8 |
4 |
4 |
400 |
1 |
16 |
|
odb-04 |
4 |
16 |
8 |
8 |
800 |
1 |
32 |
|
odb-06 |
6 |
24 |
12 |
12 |
1200 |
2 |
64 |
|
odb-12 |
12 |
48 |
24 |
24 |
2400 |
4 |
64 |
|
odb-16 |
16 |
64 |
32 |
32 |
3200 |
4 |
64 |
|
odb-20 |
20 |
80 |
40 |
40 |
4000 |
4 |
64 |