oracle 最大IOPS使用率和IOMBPS使用率监控 19c

通过字典DBA_HIST_RSRC_PDB_METRIC 分析 具体字段为IOPS_THROTTLE_EXEMPT、IOMBPS_THROTTLE_EXEMPT
一般最大值超过5就要告警了

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.

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.