1.用户反映有条delete语句跑了很久都没跑完

2.由于是测试环境，当前只有这条delete语句在运行，运行事件将近一天
DELETE from inv_unit_equip_damages where owner_entity =
‘TruckTransaction’ and owner_gkey NOT IN (select gkey from
road_truck_transactions);

3.inv_unit_equip_damages数据量为69W+
要删除18W+

4.检查后，无阻塞，等待事件是latch:cache buffer chains,查看事件具体信息无结果返回
select /+ materialize/ * from DBA_HIST_ACTIVE_SESS_HISTORY
where
sample_time between to_date(‘2019-11-11 14:00:00’,‘yyyy-mm-dd hh24:mi:ss’)
and to_date(‘2019-11-11 17:10:00’,‘yyyy-mm-dd hh24:mi:ss’)
and event=‘latch: cache buffers chains’;

5.猜测是有逻辑坏块，将inv_unit_equip_damages导出后导入，SQL正常跑完

6.用户执行了一条新的delete语句，又出现卡住的情况
DELETE from inv_unit_equip_damages where owner_entity =
‘RoadInspection’ and owner_gkey NOT IN (select gkey from
road_truck_transactions);

请问有什么排查思路吗？？