2019-09-12 KK日记，oracle 19c 容器数据初体验

最新推荐文章于 2024-07-26 17:30:46 发布

harryho

最新推荐文章于 2024-07-26 17:30:46 发布

阅读量2.4k

点赞数 1

分类专栏： ORACLE DBA 文章标签： oracle 多租户资源控制

本文链接：https://blog.csdn.net/harryho/article/details/100916365

版权

本文探讨了Oracle 19c的容器数据库（CDB）特性，旨在通过减少物理服务器和提升运维效率来节省成本。作者关注了在CDB中多个PDB的资源竞争和物理机要求，并进行了测试验证。资源管理可通过资源管理器和系统参数在CDB和PDB层面进行，允许灵活的资源控制和扩容，为构建私有云提供了可能。

摘要由CSDN通过智能技术生成

一、案例

oracle 12c 以上数据库的其中一个新特性是容器数据库，在oracle官方文档上描述使用该新特性可以带来多个好处，具体如下：

1. Cost reduction

By consolidating hardware and database infrastructure to a single set of background processes, and efficiently sharing computational and memory resources, you reduce costs for hardware and maintenance.

2. Easier and more rapid movement of data and code

By design, you can plug a PDB into a CDB, unplug the PDB from the CDB, and then plug this PDB into a different CDB. Therefore, you can easily move an application's database back end from one server to another.

3. Easier management and monitoring of the physical database

The CDB administrator can manage the environment as an aggregate by executing a single operation, such as patching or performing an RMAN backup, for all hosted tenants and the CDB root.

3. Separation of data and code

Although consolidated into a single physical CDB, PDBs mimic the behavior of traditional non-CDBs. For example, a PDB administrator can flush the shared pool or buffer cache in the context of a PDB without affecting other PDBs in the CDB.

4. Ease of performance tuning

It is easier to collect performance metrics for a CDB than for multiple non-CDBs. It is easier to size one SGA than several SGAs.

5. Support for Oracle Database Resource Manager

In any shared resource environment, administrators must manage system resources to provide a predictable environment for users and address unexpected or transient resource contenti