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 -> Re: get the sql producing lock

Re: get the sql producing lock

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 19 Mar 2006 14:58:55 +0100
Message-ID: <441d63a0$0$21110$626a54ce@news.free.fr> 






<cnwy_at_263.net> a écrit dans le message de news: 1142773921.616585.170900_at_u72g2000cwu.googlegroups.com...


| Hello,

|   Is there a simple way to get the sql statement which locked the

| object in a transaction?

|

|

|   Thanks.

|

| wy.

|




Join v$locked_object, v$session and v$sqltext/v$sqlarea.



Regards


Michel Cadot
Received on Sun Mar 19 2006 - 07:58:55 CST












Original text of this message













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