Database Administration (MOSC)

MOSC Banner

LOB segment continuously grows

edited Jun 17, 2009 3:25AM in Database Administration (MOSC) 2 commentsAnswered
Hi,

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

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