I am trying to set up a custom event in OEM 9.2. It looks like all you can
return in a custom test is a single value (one row, one column). I want to
return a value see if the event needs to be triggered and a more
descriptive report if it is triggered. Knowing that a problem exists is
almost useless unless you know where the problem is.
For example I want to see if there are any segments that can allocate < 2
extents before the tablespace is out of space. I want a critical alert if 0
extents can be allocated and a warning if 1 can be. The problem is I can
only return one row with one column to the event processor. When the event
triggers the associated message is simply "current value: n" where n is 0
or 1. I want it to list all segments that are in danger of not allocating
the next extent and how many extents they can allocate. Can this be done?
Received on Mon Aug 04 2003 - 14:34:35 CDT
