I have about 100 oracle agents
I've been requested to monitore the UNDO tablespaces
I used the tablespaces rule that does the job but has a warning and a critical value to low
I can't change those values
So I looking at creating the same rule as for the tablespaces but only for the UNDO tablespaces where I could set different values for the WARNINGs and the CRITICALs
Thank you for your help
Sr. DBA/ Foglight Admin.
what I suggest is to copy the existing rule DBO - Tablespace Used Percentage, give it a name to identify it is a custom rule and change the scope of the rule so that it only applies to UNDO tablespaces:
DBO_Tablespace where contents = 'UNDO'
Because this is a custom rule it wont be in the global admin dashboard. So I would create some new custom registry variables to hold your thresholds based on the following:
Then edit the rule conditions to use these variables.
eg for warning
condition = (#DBO_allocated_space_used_pct_for_rules# >= registry("DBO_TablespaceStorage-AllocatedUsedPct_Low"));
return DBWC_RacAndSingleInstanceRuleFilter(scope, "DBO - Tablespace Used Percentage", "2", condition);
#DBO_allocated_space_used_pct_for_rules# >= registry("DBO_TablespaceUNDOStorage-AllocatedUsedPct_Low")
Also update the alarm message to your requirements.