Back to the main page
New Study Confirms Capital Expenditure Savings with Oracle Multitenant
A new study finds that Oracle Multitenant, an option of Oracle Database 12c, drives significant savings in capital expenditures (CAPEX) by enabling the consolidation of a large number of databases on the same number or fewer hardware resources.
A white paper based on the study, “Oracle Multitenant on Oracle SuperCluster T5-8: Study of Database Consolidation Efficiency,” details the findings, which are based on both small-scale (8-tenant) and large-scale (252-tenant) consolidations. Key findings from the four tests described in the study include
- An 80 percent increase in transaction throughput
- A 50 percent better consolidation density for active online transaction processing databases
- A 50 percent reduction in storage inputs/outputs
- A 33 percent reduction in compute resources
Achieving these results “improves efficiency, density, and elasticity of database consolidation through sharing of database memory structures and background processes as compared to deployments of individual database instances on bare-metal, or databases deployed within virtual machines,” write the authors of the white paper.
CAPEX Savings Only Part of the Story
The current study concentrates on the quantifiable benefits in terms of CAPEX, but that is only part of the savings and efficiencies that Oracle Multitenant makes possible. Others include
- Dramatically simplified consolidation with no changes to the application
- Efficient database provisioning, patching, and upgrading
- Rapid thin provisioning of databases through snapshot cloning
- The ability to manage many databases as one
- Data mobility through database unplug and plug operations
- An included database self-service provisioning application
About Oracle Multitenant
A new option for Oracle Database 12c, Oracle Multitenant delivers a new architecture that allows a multitenant container database to host many fully functional pluggable databases—all with no change to existing applications. It offers benefits similar to database-schema-based consolidation without the major application changes required by that consolidation model. It eliminates virtualization sprawl, common to virtual machine (VM) consolidation solutions, and the associated pain of upgrade and patching VMs, by leveraging the manage-many-as-one framework inherent to Oracle Multitenant.
Using new SQL commands, database administrators are empowered to
- Create new pluggable databases
- Move pluggable databases between containers
- Clone pluggable databases in seconds
This autonomy enables database administrators and line-of-business developers to manage their own database environments, thus avoiding the inherent latencies in database provisioning and data management common to many data centers and providing the independence that is vital to the success of database-as-a-service deployments.
Read the white paper “Oracle Multitenant on Oracle SuperCluster T5-8: Study of Database Consolidation Efficiency.”
Find out more about Oracle Multitenant.