Database Tuning (MOSC)

MOSC Banner

enq: HW - contention wait event

edited Jan 14, 2016 10:07AM in Database Tuning (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center