Hi,
i have Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production and my db had freezed after an hour i got in alert Waited too long for a row cache enqueue lock! PID=xx three times, in trace file i get
WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! <<<
row cache enqueue: session: 70000000ebff720, mode: N, request: S
row cache parent object: address=7000000123ffa80 cid=21(dc_table_scns)
hash=9fd7d825 typ=9 transaction=70000000ef392d8 flags=0000002a
own=7000000123ffb60[700000011b00488,700000011b00488] wat=7000000123ffb70[700000011b004d8,700000011afdd78] mode=X
status=VALID/UPDATE/-/-/-/-/-/-/-
set=0, complete=FALSE
data=
0000afee f364dcfb 00020000 01000000
UDUMP
row cache enqueue: session: 70000000ebae3f0, mode: N, request: X
row cache parent object: address=700000018224230 cid=8(dc_objects)
hash=86acee10 typ=11 transaction=700000010f8e7f0 flags=00000002
own=700000018224310[700000011afe098,700000011afe098] wat=700000018224320[700000011afe2c8,700000011afe638] mode=X
status=VALID/-/-/-/-/-/-/-/-
data=
00000111 00114d56 5f504f5f 434f4d50 5241535f 48454100 00000000 00000000
00000000 13000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000 001316cd ffff0000 ffffffff 2a786b05 1d103707 786b051d
10370778 6b051d10 37070500 00000000 00000000 00000000 00000000 00000000
00000000 00000000
there aren't locks, i did shutdown immediate and restart the database and then DB go normal
Anyone can help me please
THX