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 -> table locks

table locks

From: Manvendra Jhala <mannyj_at_vspan.com>
Date: Thu, 20 Aug 1998 11:31:19 -0400
Message-ID: <35DC4146.2CB8AE42@vspan.com>


Hi all,
developers are complaining that some records in a particular table have been locked for three days, and they want to know which user has it locked.
I ve tried to query v$session + v$lock + dba_dml_locks but im not able to specify table_names at any point.

am new to ora (7.3.4) .pls help

thanks
Manvendra
mannyj_at_vspan.com Received on Thu Aug 20 1998 - 10:31:19 CDT

Original text of this message

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