Re: OEM custom events

On 4 Aug 2003 19:34:35 GMT, Chuck <chuckh_at_softhome.net> wrote:

>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?

Why not just use the stock "tablespace full" event? Doesn't really matter *which* segment is about to fill it up. In fact, with 9.x you should be using LMT and uniform extents, if any one segment is about to take the last two extents, then all segments are equally "at fault."

For example, suppose you have a tablespace MYTS allocated to 8k, with uniform extents of 1k (these numbers are not recommended, just nice round numbers for example). Now suppose you have 3 tables, T1, T2, and T3, with, respectivly, 2 extent (2*1k), 2 extents (2*1k) and 3 extents (3*1k). If any one of these takes another extent, you will exhaust the TS. Which one do you want your custom event to identify? Does it matter? Received on Tue Aug 05 2003 - 08:00:48 CDT