Re: script for detect user blocking problem

From: Odd Morten Sveås <odd.morten.sveas_at_accenture.com>
Date: 19 Oct 2002 14:52:34 -0700
Message-ID: <4306a83.0210191352.4fdf9e5e@posting.google.com>

"tshen" <tshen01_at_hotmail.com> wrote in message news:<Pscs9.30028$eW3.4335_at_news4.srv.hcvlny.cv.net>...
> hi, guys:
>
> Our boss ask us to write a script which can detect DB users's blocking
> problems for every 10 seconds, any existing scripts can I find? or any dba
> tables I can use to find those
> blocking information that I need. thanks.
>
> Tshen

If it is lock on tables you mean, you can use the view v_$locked_object together with all_objects an v_$session.

Then again, there is not nessesarly wrong that a table have locks on it. Actualy it is most ofen correct.

Regards
Odd M Received on Sat Oct 19 2002 - 16:52:34 CDT