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

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<Xns9322BAB3328C4SunnySD_at_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!

Sorry I Left out the details
HP unix Oracle 8.1.7
TIA
Mike Received on Mon Feb 17 2003 - 13:48:22 CST