可以阅读和参考MOS文档 《 Analyzing ‘enq: HW - contention’ Wait Event (Doc ID 740075.1)》
enq: HW - contention和gc buffer busy acquire等待事件我理解应该是有大量insert导致的,但是看了下SQL ordered by Elapsed Time ,insert语句执行次数也不是很多
有没有ash dump,通过分析ash,分析下堵塞链,可以初步定位到底是哪个是受害者
根据p3值。即可得到segment_name
SQL> select dbms_utility.data_block_address_block(p3值) block#,dbms_utility.data_block_address_file(p3值) file# from dual;
假设求得file_id=1,block_id=80288:
SQL> select segment_name from dba_extents where rownum = 1 and file_id = 1 and 80288 between block_id and block_id + blocks - 1;