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.