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 given table ?

How to get locked rows for a given table ?

From: <michael_at_isv-gmbh.de>
Date: 1997/02/10
Message-ID: <32FF1DAF.6071@isv-gmbh.de>#1/1 







I like to determine the locked rows for a table. But I don't have enough
info on the *$ (system) tables... I'd like to have a SQL-Statement or a
PROCEDURE that accepts a table name and returns a vector (or a table).



I don't want to use SELECT ... NOWAIT ! This requires a table scan. The
table is too big to be scanned at least once in two minutes.



replies via email preferred - thanks.
Received on Mon Feb 10 1997 - 00:00:00 CST












Original text of this message













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