Oracle consolidating databases datingtheyoungerman com
Things were much simpler in the pre-relational days of "glass house" servers.With IMS or IDMS on a mainframe, I would only need to perform an upgrade once, and I could easily gen-in the upgrades to dozens of "instances," all at my leisure.Fewer databases sharing resources increase utilization, in turn requiring less infrastructure and management.Less infrastructure lowers costs for software licensing, hardware and data center facilities.Using IBM's virtualization tools, Oracle instances can be partitioned into logical partitions (LPAR's), while sill maintaining the ability for critical tasks to use all CPU resources for super-fast Oracle parallel query."Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.Oracle database consolidation reduces the number of databases, effectively pooling database resources. Figure 1 Don't confuse database consolidation with server and storage consolidation.Server consolidation -- implemented as operating system virtualization -- and storage consolidation -- implemented as shared storage -- put the same number of databases on fewer physical servers and storage systems.
Figure 2 To understand Oracle database consolidation, let's simplify the architecture to its basic construct, the database server.
The proliferation of databases, sometimes referred to as database sprawl, is expensive and difficult to manage.
To reverse this trend, you must move to a multitenant database deployment model by consolidating databases.
For others, schema-based shared deployments have had limited success. Oracle Database 12c offers a new option called Oracle Multitenant, which simplifies and improves Oracle database consolidation and, thus, your ability to scale.
The success of more than two decades of database deployments has created an IT dilemma -- a lot of databases and an increasing total cost of ownership (TCO).