enq: HW - contention wait event
Hi
On my production database , I can see the "enq: HW - contention wait event" wait event responsible for 92% of the database time.
How can we deal to fix this problem ?
Any hints or advice would be appreciated.
this is the script of the table impacted :
>>
CREATE TABLE DOCFACTORY.DF_BROADCAST_DATA
(
ID NUMBER(19) NOT NULL,
DATA BLOB NOT NULL,
NAME VARCHAR2(255 CHAR),
TYPE VARCHAR2(255 CHAR),
TRANSACTIONID VARCHAR2(500 CHAR),
BROADCAST_DATA_ID NUMBER(19)
)
LOB (DATA) STORE AS BASICFILE (
TABLESPACE DOCFACTORY_BIG_DATA
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
LOGGING
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT