Re: Unable to find SQL executed by blocking session
- From: rjamya <rjamya@xxxxxxxxx>
- To: "Bobak, Mark" <mark.bobak@xxxxxxxxxxxxxxx>
- Date: Fri, 15 Oct 2004 11:54:01 -0400
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> /
** Active Locks in "RELNCS" ordered by RESOURCE **
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
