Re: Script to query data dictionary and post message to alert log| mail results

Home -> Community -> Usenet -> c.d.o.server -> Re: Script to query data dictionary and post message to alert log| mail results

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 15 Feb 2003 02:21:11 GMT
Message-ID: <Xns9322BAB3328C4SunnySD@68.6.19.6>

mngong_at_yahoo.com (michael ngong) wrote in news:ecf365d5.0302120721.7b3184bd_at_posting.google.com:

> Trying to monitor long running queries from v$session_longops and
> v$session and allow the supplied procedure dbms_system.kdswrt to write
> errors to alert log with a custom created ORA# or mail the results
> alternatively.This should permit a third party tool to pick it up
> or the results could be mailed directly to certain users.
> I have not succeeded in making it work and would appreciate some
> expert help
> Thanks
> Mike

Sorry my crystal ball is in the shop for repair.

No OS or OS version.
No Oracle version.
No error messages

Therefore no helpful suggestions are forthcoming. FWIW - It works for me on my systems.

HTH & YMMV HAND! Received on Fri Feb 14 2003 - 20:21:11 CST