Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: tablespaces size monitoring question
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
![]() |
![]() |