Re: tablespaces size monitoring question

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 1 Aug 2002 17:26:53 +1000
Message-ID: <vh529.50078$Hj3.149872@newsfeeds.bigpond.com>

Hi Murty,

My suggestion would be to make use of OEM's Event capability and set the Tablespace Full event as appropriate. All the functionality you describe is there and sitting ready to be used.

Cheers

Richard
"Murty Adavi" <adavi_at_attbi.com> wrote in message news:%e%19.716025$352.157147_at_sccrnsc02...
> I would like to setup some kind of alert mechanish when the free space in
a
> tablespace falls below
> a certain threshold ... say 30 %.
>
> (Simalar to setting up a threshold procedure in Sybase where Sybase
server
> automatically kicks off
> a stored proc when the free space in a segment falls below a
predefined
> level and I can call a Unix
> shell script from that stored proc to page/Email ...)
>
> What is the best way to achieve this in Oracle? I would like to avoid
> polling mechanish (setting up a cron job
> to execute a shell script that in turn connects to the database
periodically
> and checks dba_free_space & dba_data_files)
>
> Thanks......
> Murty
>
>
Received on Thu Aug 01 2002 - 02:26:53 CDT