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 for detect user blocking problem

Re: script for detect user blocking problem

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 21 Oct 2002 08:47:43 -0700
Message-ID: <336da121.0210210747.1fa1f4b8@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




Look up utllockt.sql in $ORACLE_HOME/rdbms/admin
Received on Mon Oct 21 2002 - 10:47:43 CDT












Original text of this message













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