Re: Unable to find SQL executed by blocking session

Thanks Juan,=20

to give you an idea, my script offers following output ... and I like
what I am showing to app support personnel. It is partially based on
Steve Adam's script.


** Active Locks in "RELNCS" ordered by RESOURCE **

    INST RESOURCE               SID S DB/OS User           HOLDING
WANTING LCKTIM HASH VALUE
-------- -------------------- ----- - -------------------- -------
------- ------ ---------------
 RELNCS1 TX-131116-329796        38 I TCS/ORACLEI                X   =20
       105               0
 RELNCS2 TX-131116-329796        35 A TCS/ORACLEI                    =20
  X    100      1436257755

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

Resource WAITER "TCS/oraclei" is logged on "RELNCS2" and waiting for
the lock for last "100" seconds."
Partial SQL statement (hash value: 1436257755) 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.28
SQL> exit=20

See that hash_value of 0 for BLOCKER? Tha'ts what my problem is.

Cheers
Raj
--
http://www.freelists.org/webpage/oracle-l

Other related posts: