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 -> Which tables are locked by apps(oracle financials 11.0.3) user ?

Which tables are locked by apps(oracle financials 11.0.3) user ?

From: Mehul Zaveri <mehulzaveri_at_hotmail.com>
Date: Sun, 12 Sep 1999 13:47:33 +0400
Message-ID: <7rfsha$t5u8@news.emirates.net.ae> 





Hi friends,


Can we find out, which apps users are holding locks on which tables.
(i.e. a link between fnd_% and v$transaction, v$process, v$session etc.)
I am able to find table name from dba_dml_locks, but which apps user is
locking?



Any help/pointer would be greatly appreciated.



Kind regards,


Mehul Zaveri,


Oracle DBA


EPPCO-DUBAI



Received on Sun Sep 12 1999 - 04:47:33 CDT












Original text of this message













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