How to know the bind value in 9i
I often notice deadlock in my one of database. This is two node RAC. I wanted to know bind value for this :1 variable.
Any input ? , This is 9i DB.
Here is the complete trace.
=================
user session for deadlock lock 0x5e14f85c
pid=36 serial=59495 audsid=30538790 user: 69/PROD
O/S info: user: , term: , ospid: 1234, machine: prd003
program:
Current SQL Statement:
delete from ORDER where ORDER_ID=:1
Global Wait-For-Graph(WFG) at ddTS[0.9374] :
BLOCKED 0x5e14f85c 5 [0xa000c][0x40fe1c],[TX] [2359297,2058455] 0
BLOCKER 0x5d14e964 5 [0xa000c][0x40fe1c],[TX] [12845058,550] 1
BLOCKED 0x5d14e2c4 5 [0x2b0021][0x129e9a],[TX] [12845058,550] 1