Oracle-L: RE: Database tracking

From: Charu Joshi <joshic_at_mahindrabt.com>
Date: Thu, 16 Jan 2003 08:04:17 -0800
Message-ID: <F001.00531734.20030116080417@fatcity.com>

Pardon me, but I don't think I have got the full version of what Ethan sent. (See below..)

Also, when my yesterday's post appeared in the list, the text from 'begin' onwards was missing.

Is it possible that 'begin' is a keyword for the mail server?

Thanks & regards,
Charu

-----Original Message-----

Sent: Wednesday, January 15, 2003 9:54 PM To: Multiple recipients of list ORACLE-L

worlds_smallest_perfmon
--
Monitors wait time and logs information to database alert logs.
--
p_interval = # of minutes to wait between checks
p_alert = # of seconds per minute spent in wait that triggers alert
--
This code is completely untested, use at your own risk. Run this for
a few hours to establish a baseline for performance and set you your
alert log monitor to capture the alert string. Consider adding or
removing events from those used to calculate the total wait time.
--
--
create or replace procedure worlds_smallest_perfmon (p_interval number, p_alert number) is l_new_total number(8,0) := 0; l_old_total number(8,0) := 0; l_diff number(8,0) := 0; l_log varchar2(50);

Disclaimer

This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

Visit us at http://www.mahindrabt.com

--

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

Author: Charu Joshi
INET: joshic_at_mahindrabt.com

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 - 10:04:17 CST