|
Chains most likely to have caused the hang:
《《《最
终
阻塞源都是由于
resmgr:cpu quantum
引起。
[a] Chain 1 Signature: '
resmgr:cpu quantum
'<='buffer busy waits'<='buffer busy waits'<='enq: TX - index contention'
Chain 1 Signature Hash: 0xe7466825
[b] Chain 2 Signature: '
resmgr:cpu quantum
'<='buffer busy waits'
Chain 2 Signature Hash: 0x23972dee
[c] Chain 3 Signature: '
resmgr:cpu quantum
'<='buffer busy waits'
Chain 3 Signature Hash: 0x23972dee
====================================================================
Chain 1:
-------------------------------------------------------------------------------
Oracle session identified by:
{
instance: 1 (jfdb.jfdb1)
os id: 78941
process id: 1240, oracle@XXX-JF-DB03
session id: 22 <<<< session 22
session serial #: 32445
}
is waiting for 'enq: TX - index contention' with wait info:
{
p1: 'name|mode'=0x54580004
p2: 'usn<<16 | slot'=0x1cb0015
p3: 'sequence'=0xf3fa7
time in wait: 0.122389 sec
timeout after: never
wait id: 199367
blocking: 0 sessions
wait history:
* time between current wait and wait #1: 0.000318 sec
………
}
and is blocked by <<<<
被阻塞
=> Oracle session identified by:
{
instance: 1 (jfdb.jfdb1)
os id: 1349
process id: 2756, oracle@XXX-JF-DB03
session id: 3320 <<<<session 3320
session serial #: 3849
}
which is waiting for ‘buffer busy waits’ with wait info:
{
p1: ‘file#’=0x8c
p2: ‘block#’=0x286540
p3: ‘class#’=0x1
time in wait: 0.218850 sec
timeout after: never
wait id: 51286
blocking: 58 sessions
wait history:
……….
}
and is blocked by <<<<
被阻塞
=> Oracle session identified by:
{
instance: 1 (jfdb.jfdb1)
os id: 3182
process id: 2975, oracle@XXX-JF-DB03
session id: 5658 <<<session 5658
session serial #: 181
}
which is waiting for 'buffer busy waits' with wait info:
{
p1: 'file#'=0x8c
p2: 'block#'=0x285b1f
p3: 'class#'=0x1
time in wait: 0.219271 sec
timeout after: never
wait id: 38737
blocking: 63 sessions
wait history:
。。。。。。
}
and is blocked by<<<<
被阻塞
=> Oracle session identified by:
{
instance: 1 (jfdb.jfdb1)
os id: 27602
process id: 2384, oracle@XXX-JF-DB03
session id: 334
《《《session 334
session serial #: 757
}
which is waiting for 'resmgr:cpu quantum' with wait info:
{
p1: 'location'=0x2
p2: 'consumer group id'=0x3259
p3: ' '=0x0
time in wait: 0.040860 sec
timeout after: never
wait id: 95941
blocking: 114 sessions
wait history:
。。。。。。。
}
Chain 1 Signature: 'resmgr:cpu quantum'<='buffer busy waits'<='buffer busy waits'<='enq: TX - index contention'
Chain 1 Signature Hash: 0xe7466825
|