LOB segment continuously grows
we run a J2EE app on JBoss that connects to a Oracle DB (11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production ( Windows Server)).
Our application produces heavy load on the JBoss internal jms provider.
INSERT-, UPDATE- and DELETE-statements to a table named "TJMSMESSAGES" are executed by the jms provider for each jms transaction.
We have up to 150 transactions/second.
As far as i know, the LOB column is written once but never updated.
TJMSMESSAGES:
CREATE TABLE "TJMSMESSAGES" ( "CMESSAGEID" NUMBER(19), "CDESTINATION" VARCHAR2(150), "CTXID" NUMBER(19), "CTXOP" CHAR(1), "CMESSAGEBLOB" BLOB, "CRECEIVEDTIME" TIMESTAMP(6) DEFAULT SYSTIMESTAMP , CONSTRAINT "PK_TJMSMESSAGES" PRIMARY KEY ("CMESSAGEID", "CDESTINATION") VALIDATE ) TABLESPACE "DATA" PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) NOLOGGING NOCOMPRESS LOB ("CMESSAGEBLOB") STORE AS SECUREFILE ( TABLESPACE "LOB" DISABLE STORAGE IN ROW RETENTION NONE KEEP_DUPLICATES NOCOMPRESS STORAGE ( INITIAL 104K BUFFER_POOL DEFAULT) NOCACHE NOLOGGING ) ENABLE ROW MOVEMENT