Enqueue - TX Waits - 2 node 9.2.0.7 RAC
we have a 2 node 9i RAC (9.2.0.7) system on windows 32 bit
we tried to run an update SQL on the system that just stayed there for 3+ hours and based
on the statistics returned from TOAD, it estimated that the update would be completed in 30 days
Here is the SQL
update TABLE_A set DW_SGRP_SEQ=
(select tp_sgrp_seq from TABLE_B where TP_SEQ=DW_DENY_SEQ)
TABLE_A has 11 milltions rows, 140,000 blocks and the size of the table is about 1 GB
TABLE_B has 1 milltions rows, 13,000 blocks and the size of the table is about 250 MB
There is index on DW_SGRP_SEQ,TP_SEQ and DW_DENY_SEQ
we tried to run an update SQL on the system that just stayed there for 3+ hours and based
on the statistics returned from TOAD, it estimated that the update would be completed in 30 days
Here is the SQL
update TABLE_A set DW_SGRP_SEQ=
(select tp_sgrp_seq from TABLE_B where TP_SEQ=DW_DENY_SEQ)
TABLE_A has 11 milltions rows, 140,000 blocks and the size of the table is about 1 GB
TABLE_B has 1 milltions rows, 13,000 blocks and the size of the table is about 250 MB
There is index on DW_SGRP_SEQ,TP_SEQ and DW_DENY_SEQ
0