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 -> How to get locked rows for a table ?

How to get locked rows for a table ?

From: Michael Agbaglo <byteshif_at_cs.tu-berlin.de>
Date: 1997/02/24
Message-ID: <01bc15d9$83500fc0$0200000a@pitfall>#1/1 







Looking for a SELECT statement or a PROCEDURE that returns ROWIDs from
locked rows for a given table. I would do it myself but I don't have enough
info on the tables ending with $.



Please don't tell me to use SELECT ... NOWAIT - That's the (most?)
inefficient way to do it: It needs two tablescans...



replies via email preferred - thanks !
Received on Mon Feb 24 1997 - 00:00:00 CST












Original text of this message













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