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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 20 Mar 2006 20:15:29 +0100
Message-ID: <ipvt12pnfhqcpdlsjctrh4e0vd18nqe684@4ax.com> 





On Mon, 20 Mar 2006 12:34:52 -0500, NetComrade
<netcomradeNSPAM_at_bookexchange.net> wrote:



>I am not aware of 'current transaction sql'.





You could find that by linking v$session.taddr to
v$transaction.address


--
Sybrand Bakker, Senior Oracle DBA


Received on Mon Mar 20 2006 - 13:15:29 CST












Original text of this message













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