Description:

Currently, the Oracle ASM management pack in OBM allows us to monitor ASM tablespaces based on percentage usage. However, this approach presents challenges in managing thresholds effectively, especially given the distinct characteristics of the DATA and RECO tablespaces. DATA tablespaces are typically in terabytes (TBs), while RECO tablespaces are in gigabytes (GBs). A single percentage-based threshold is not suitable for both disk groups due to their differing sizes.

Proposed Enhancements:

Threshold Management by Space:
Implement threshold management based on absolute space (GBs/TBs) instead of percentage usage.
Allow independent threshold settings for different disk groups (DATA and RECO).

Alerting Based on Free Space:
Trigger alerts based on available free space in GBs.
This will simplify the identification and prompt action on alerts without the need for manual calculations to convert percentages to GBs/TBs.

Automation for Active DB Instance:
Enable automation to ensure ASM is active only on the active database instance.
This will prevent unnecessary alerts from passive instances and reduce manual switchovers.

Current MP Sample Alert:

Free space percentage (2.70) too low for DB001234_DATA in database +ASM1 (<=25.00%). Free space 127196.00MB, total space 4710400.00MB. Associated +ASM.

These enhancements will significantly improve the efficiency and accuracy of ASM monitoring and management in OBM.