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.
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.
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_MBPS.html#GUID-9F7E0143-76FB-488A-9A04-2D85F1417CB6
当然这个告警需要通过压力测试设置参数 MAX_MBPS和MAX_IOPS
标签：database,MAX,throttling,IOPS,megabytes,oracle,使用率 From： https://www.cnblogs.com/dbahrz/p/17446781.html