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: How to know which row is locked ?

Re: How to know which row is locked ?

From: <Clive>
Date: 1998/10/08
Message-ID: <361d0736.6808853@news.demon.co.uk>#1/1

On Tue, 06 Oct 1998 16:51:35 +0100, Ulrich Brandes <ulrich.brandes_at_technet.net> wrote:

><HTML>
>Hi ,
>
><P>take a lock on the CATBLOCK.SQL Script which should be installed on
>the
><BR>SYS Schema. This Script creates View of Oracle Locks.
><BR>&nbsp;
>
><P>Hope this helps...
><BR>&nbsp;
>
><P>U. Brandes
>
><P><TT>----------------------------------------------------------------------------------------------------</TT>
><BR><TT>FS-EDV Service &amp; Beratung&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>Oracle Alliance Partner</TT>
><BR><TT>An der P&ouml;nt 48&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>Novell autorisierter Partner</TT>
><BR><TT>40885 Ratingen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>registrierter Microsoft H&auml;ndler</TT>
><BR><TT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>IBM Business Partner</TT>
><BR><TT>Fon +49-(0)2102-186-400</TT>
><BR><TT>Fax +49-(0)2102-186-499</TT>
><BR><TT>email ubrandes_at_fs-edv.de</TT>
><BR><TT>------------------------------------------------------------------------------------------------------</TT>
><BR>&nbsp;</HTML>
>

The only problem is that the views created don't show which rows are locked.

Regards,

Clive.

--
Clive Bostock
Received on Thu Oct 08 1998 - 00:00:00 CDT

Original text of this message

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