oracle 最大IOPS使用率和IOMBPS使用率监控 19c
pdb最大iops使用率监控指标获取
通过字典DBA_HIST_RSRC_PDB_METRIC 分析 具体字段为IOPS_THROTTLE_EXEMPT、IOMBPS_THROTTLE_EXEMPT
一般最大值超过5就要告警了
参数 iops_throttle_exempt
Indicates how much of the I/O per second in the current PDB was exempted from throttling. For example, if the value in the IOPS column is 20 I/Os and the value in the IOPS_THROTTLE_EXEMPT column is 5 I/Os, then 5 I/Os of the 20 I/Os in that second were exempted from throttling. I/O throttling is defined by the MAX_IOPS database initialization parameter.
1 | https: //docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_IOPS.html#GUID-7D89F457-0CE6-4152-98EA-7F1BE4E0ADC7 |
参数
IOMBPS_THROTTLE_EXEMPT
Indicates how many megabytes of I/O executed per second in the current PDB were exempted from throttling. For example, if the value in the IOMBPS column is 200 megabytes and the value in the IOMBPS_THROTTLE_EXEMPT column is 50 megabytes, then 50 megabytes of the 200 megabytes were exempt from throttling. I/O megabytes per second throttling is defined by the MAX_MBPS database initialization parameter.
1 | https: //docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_MBPS.html#GUID-9F7E0143-76FB-488A-9A04-2D85F1417CB6 |
当然这个告警需要通过压力测试设置参数 MAX_MBPS和MAX_IOPS
本文来自博客园,作者:蚌壳里夜有多长,转载请注明原文链接:https://www.cnblogs.com/dbahrz/p/17446781.html
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了