Hi, i am using Release 11.2.0.3.0 version of oracle. its 2 node RAC
Recently we are observing frequent 'Enq-HW Contention' in our database and the query is Insert which was expected and its always the same one. And its executed concurently which is unavoidable. Just analysing little deeper found that it contains one CLOB column, and then i verified that both the tablespace storing table data and lob(checked from DBA_LOBS) are already on ASSM. and having below configuration for same. So how to overcome this contention?
block_size initial_extents max_extents max_size
8192 65536 2147483645 2147483645
Query:
insert into A (C1, C2_CLOB, C3, C4) values (:1, :2, :3, :4);