Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unable to find SQL executed by blocking session

Re: Unable to find SQL executed by blocking session

From: rjamya <rjamya_at_gmail.com>
Date: Fri, 15 Oct 2004 11:54:01 -0400
Message-ID: <9177895d04101508543c5f11e3@mail.gmail.com>


Yey !!!

thanks Mark ... that was it, now I use gv$session.prev_hash_value for the blocker session and I get what I want ....

SQL> /

    INST RESOURCE SID S DB/OS User HOLDING WANTING LCKTIM HASH VALUE

-------- -------------------- ----- - -------------------- -------
------- ------ ---------------
 RELNCS1 TX-196612-235740        38 I TCS/ORACLEI                X   =20
         9               0
 RELNCS2 TX-196612-235740        35 A TCS/ORACLEI                    =20
  X      6      1308698167

Resource BLOCKER "TCS/oraclei" is logged on "RELNCS1" and holding the lock for last "9" seconds."
Partial SQL statement (hash value: 0) executed by the BLOCKER is as follows=  ...

<BLOCKER> update /* test */ raj_test set a =3D :"SYS_B_0"

Resource WAITER "TCS/oraclei" is logged on "RELNCS2" and waiting for the lock for last "6" seconds."
Partial SQL statement (hash value: 1308698167) executed by the WAITER is as follows ...

<WAITER> update raj_test set a =3D :"SYS_B_0"

Database lock Info, ESPN Oracle Utilities, =A9 ESPN 2004 Elapsed: 00:00:00.32=20

Thanks a bunch !!
Raj

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 15 2004 - 10:50:55 CDT

Original text of this message

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