Orcle 12c 新特性---限制PDB的IO

最新推荐文章于 2022-08-21 17:16:32 发布

Expect-乐

最新推荐文章于 2022-08-21 17:16:32 发布

阅读量450

点赞数 1

分类专栏： Oracle 12c 文章标签： MAX_IOPS MAX_MBPS

本文链接：https://blog.csdn.net/qianglei6077/article/details/92795940

版权

Oracle 12c 专栏收录该内容

98 篇文章 4 订阅

订阅专栏

1 说明

You can set the MAX_IOPS initialization parameter and the MAX_MBPS initialization parameter to limit the disk I/O generated by a PDB.

主要是为了限制PDB的I/O，来控制整体CDB性能，保证其他PDB能有足够的I/O资源可用。

A large amount of disk I/O can cause poor performance. Several factors can result in excess disk I/O, such as poorly designed SQL or index and table scans in high-volume transactions. If one PDB is generating a large amount of disk I/O, then it can degrade the performance of other PDBs in the same CDB.

The MAX_IOPS initialization parameter limits the number of I/O operations for each second. --限制I/O次数
The MAX_MBPS initialization parameter limits the megabytes for I/O operations for each second. --限制I/O字节数
注意：如果在CDB级别设置这两个参数，那么会限制CDB里的所有PDB I/O

1.1 设置方式

SQL> ALTER SYSTEM SET MAX_IOPS = 1000 SCOPE = BOTH;
System altered.

SQL> ALTER SYSTEM SET MAX_MBPS = 5 SCOPE = BOTH;
System altered.

1.2 查看PDB I/O使用情况

You can use the DBA_HIST_RSRC_PDB_METRIC view to calculate a reasonable I/O limit for a PDB. Consider the values in the following columns when calculating a limit: IOPS, IOMBPS, IOPS_THROTTLE_EXEMPT, and IOMBPS_THROTTLE_EXEMPT. The “rsmgr:io rate limit” wait event indicates that a limit was reached.

可以使用DBA_HIST_RSRC_PDB_METRIC视图来计算PDB的合理I / O限制。在计算限制时，请考虑以下列中的值：IOPS，IOMBPS，IOPS_THROTTLE_EXEMPT和IOMBPS_THROTTLE_EXEMPT。 “rsmgr：io rate limit”等待事件表示达到I/O限制。