Database Tuning (MOSC)

MOSC Banner

How to know the bind value in 9i

edited Jun 7, 2011 2:30AM in Database Tuning (MOSC) 5 commentsAnswered
 Hi ,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center