Has anyone ever written a custom OEM event they'd be willing to share
that checks the number of times a segment can extend before running out
of space? I don't want to use the prepackaged Tablespace Full or Chunk
Small events as they both fall short of what I want. I size my extents to
give me 3-4 days of growth. I want to alarm when there are 2 free extents
remaining. Chunk small requires the free extents to be contiguous which
isn't always the case and yields plenty of false alarms. Tablespace full
is based on percentages and the threshholds would constantly need to be
tweaked as the tablespace grows. Since my tablespaces are all LMT's, I'm
looking for something that just divides the total free space available in
the tablespace by the next extent size. It sounds simple but I haven't
had time to write something and integrate it with OEM. I was hoping
someone else has already done it and would be willing to share what
they've done.
Our environment is a 9.2 OMS, with agents ranging from 8.1.7.4 up through
9.2.
--
Chuck
Remove "_nospam" to reply by email
Received on Tue Dec 02 2003 - 08:03:10 CST
