Locked record - how to find out ?

From: Igor V. Podolsky <igoryok_at_soft-review.kiev.ua>
Date: Thu, 13 Jan 2000 13:51:02 +0200
Message-ID: <AAQmRVuS80H@soft-review.kiev.ua>

Hi !

Oracle perfoms lock of record after it update. Lock keeps till commit or rollback. Thats fine. But is there a way to determine what record of some table is locked by some user ? Of course, I can perfom 'select for update' statement. But I only can find out if is some record locked. But I need to get a list of table records that is locked. Is it possible ?

P.S. Please duplicate answers to igoryok_at_soft-review.kiev.ua.

--
Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91) Received on Thu Jan 13 2000 - 05:51:02 CST