Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sat, 15 Feb 2003 15:34:26 -0800
Message-ID: <3E4ECE82.2CD13054@exesolutions.com>


"Ana C. Dent" wrote:

> 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!
CLAP CLAP CLAP! Daniel Morgan Received on Sat Feb 15 2003 - 17:34:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US