tablespaces size monitoring question

From: Murty Adavi <adavi_at_attbi.com>
Date: Thu, 01 Aug 2002 00:26:35 GMT
Message-ID: <%e%19.716025$352.157147@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 Wed Jul 31 2002 - 19:26:35 CDT