Oracle-L: RE: Unix Max Extent Script

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Thu, 16 Jan 2003 12:40:07 -0800
Message-ID: <F001.00532044.20030116124007@fatcity.com>

Run as stored procedure scheduled using DBMS_JOB and if an alert occurs send it to the alert log using the procedure in DBMS_SYSTEM. I presume you already have a system which monitors you alert logs so it should be pretty easy to generate your email/pages without any further modification without creating a whole bunch of new scripts for people to manage.

If you still insist on going the UNIX scripting route please DO NOT write a specific script to check extents. Instead write a script which runs any .sql file and checks for rows returned, then takes some action based upon the fact that rows are returned or not. Now you can use this single script to run any number of checks against your database.

Ethan

-----Original Message-----
Sent: Thursday, January 16, 2003 12:36 PM To: Multiple recipients of list ORACLE-L

I have found many great SQL scripts to identify segments whose next extents will not fit into their tablespace and segments whose number of extents are approaching the max number of extents. But, what I am looking for is a Unix shell script that will run one of these scripts and mail alerts based on the results. Has anyone written a shell script that will do this that they would like to share? There are many other SQL scripts that I would like to run from cron to evaluate SQL script results.

Thanks
Erik
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Post, Ethan
INET: Ethan.Post_at_ps.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 16 2003 - 14:40:07 CST