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: Who selects FOR UPDATE?

Re: Who selects FOR UPDATE?

From: Ken Geng <ken.geng_at_cbis.com>
Date: 1997/03/18
Message-ID: <332EEA39.404F@cbis.com>#1/1 







Volker Hauswurz wrote:


.> 

.> Once I read that you can get the information which user has a lock on

a row


.> when he SELECTs FOR UPDATE.

.> But I forgot it and I can't find the system view or routine which

gives me


.> the information. Can anybody help me?

.> 

.> Thanks

.>    Volker




How about these system tables/views?


DBA_DML_LOCKS
DBA_DDL_LOCKS
DBA_LOCKS




V$LOCK.

Received on Tue Mar 18 1997 - 00:00:00 CST












Original text of this message













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