Re: what determines the info sent to the alert log and trace files

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1114304722.183056.32070_at_f14g2000cwb.googlegroups.com...
> It's not a bad idea to setup some monitoring that runs periodically and
> checks on sessions growing large allocations of sort space. Catch them
> running, get the sql, find out who is running it and why ... maybe kill
> them if they get too large?
>
> Resumable sessions is also a possible approach as Mr. Lewis noted.
>
> I can dig up a script that I have at work (sometime next week) that
> demonstrates how to monitor allocations, do some logging, capture the
> sql, etc. But it's a not a bad idea to see if you can do that yourself
> as a learning exercise.
>

I have a couple of scripts which check sort space, extents. The issue seems to be that one misses the event I guess from a scheduler one could run it every minute. Received on Mon Apr 25 2005 - 09:41:30 CDT