Re: Using fixit Job

From: Joel Garry <joel-garry_at_home.com>
Date: 23 May 2003 17:24:22 -0700
Message-ID: <91884734.0305231624.3557461d@posting.google.com>

"Yanick Quirion" <neokimia_at_hotmail.com> wrote in message news:<p69za.130070$nA6.1445295_at_charlie.risq.qc.ca>...
> Hi all,
>
> I want to use a fixit job to automatically add space to a tablespace when it
> reach the warning level. What script I can right into the fixit job to only
> add, for example 5MB to a tablespace, without adding a datafiles nor use the
> autoextend option for the tablespace. I want to be notified when a
> tablespace excess 90% of space use, and if I use the autoextend, I will not
> be notified.

You could find the free version of Big Brother, which is just a bunch of scripts, and have it both do this and notify you and even change the color of a web page your browser is pointed towards. Or it could just tell you when autoextend did it's thing.

http://bb4.com/

>
> Thanks
>
> Regards,
> -Yanick

--
@home.com is bogus.
But then again, inventing wheels is educational.

Received on Fri May 23 2003 - 19:24:22 CDT