Database Reference
In-Depth Information
analysis initiated by oradebug
os thread scheduling delay history: (sampling every 1.000000 secs)
0.000000 secs at [ 17:19:17 ]
NOTE: scheduling delay has not been sampled for 0.977894 secs 0.000000 secs from
[ 17:19:14 - 17:19:18 ], 5 sec avg
0.000323 secs from [ 17:18:18 - 17:19:18 ], 1 min avg
0.000496 secs from [ 17:14:19 - 17:19:18 ], 5 min avg
===============================================================================
Chains most likely to have caused the hang:
[a] Chain 1 Signature: 'SQL*Net message from client'<='enq: TX - row lock contention'
Chain 1 Signature Hash: 0x38c48850
===============================================================================
Non-intersecting chains:
-------------------------------------------------------------------------------
Chain 1:
-------------------------------------------------------------------------------
Oracle session identified by: << waiter >>
{
instance: 2 (rondb.rondb2)
os id: 12250
process id: 40, oracle@hostname (TNS V1-V3)
session id: 103
session serial #: 1243
}
is waiting for
'enq: TX - row lock contention' with wait info:
{
p1: 'name|mode'=0x54580006
p2: 'usn<<16 | slot'=0x20001b
p3: 'sequence'=0x101fc
time in wait: 21.489450 sec
timeout after: never
wait id: 33
blocking: 0 sessions
current sql
: update emp set sal=sal+100 where eno=1
and is blocked by
=> Oracle session identified by: << holder >>
{
instance: 1 (imcruat.imcruat1)
os id: 8047
process id: 42, oracle@usdbt42 (TNS V1-V3)
session id: 14
session serial #: 125
}
which is waiting for 'SQL*Net message from client' with wait info:
{
p1: 'driver id'=0x62657100
p2: '#bytes'=0x1
time in wait: 27.311965 sec
