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 -> Who is locking a record (not just a table)

Who is locking a record (not just a table)

From: S. Han <shan168_at_yahoo.com>
Date: Wed, 05 Jan 2000 02:01:17 GMT
Message-ID: <84u8l5$ugn$1@nnrp1.deja.com> 





Hi,



Is there any view in Oracle8 to display which user is locking what
records? We are in the development of a VB6 application which requires
to display userid who is currently locking the record. Such as:



The reocrd is locked by USERID!



V$session view can only provide object_id which doesn't go down to ROW
level. Several users can access the same table but different rows.



Any help will be appreciated!



Steph




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Tue Jan 04 2000 - 20:01:17 CST












Original text of this message













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