Log file sequential read wait on delete from IOT
Has anybody run into a situation where deleting from an IOT ends up hanging on a log file sequential read wait? Looking at the statistics it has deleted 1500 rows before it has this problem. It ends up blocking updates to another table that has as the primary key a column that is setup as a foreign key in the IOT. We are currently running 11.1.0.7 on a 64-bit Linux platform.