Database Tuning (MOSC)

MOSC Banner

Optimizing BLOB storage parameters

edited Jul 25, 2011 3:44AM in Database Tuning (MOSC) 3 commentsAnswered
Team,

        I am creating the following table with BLOB datatype in Oracle 11.2 on Linux
CREATE TABLE workItemReq (
REQUESTID        NUMBER(10),
USERID           VARCHAR2(25),
WORKITEMID       VARCHAR2(64) NOT NULL,
USERLABEL        VARCHAR2(1024),
DATATYPE         NUMBER(2) NOT NULL,
DATAID           NUMBER(10),
STRDATAID        VARCHAR2(1024),
RETURNFLAG       NUMBER(1),
CLOSINGACTION    NUMBER(1),
TASKMODELNAME    VARCHAR2(32),
PARAMETERS       BLOB
)
        PCTUSED 20
        PCTFREE 60
        INITRANS 60
TABLESPACE OM_DATA02_07
STORAGE  (
        INITIAL 16M
        NEXT 16M
        MINEXTENTS 1
        MAXEXTENTS UNLIMITED
        FREELISTS 20
        PCTINCREASE 0
        )
        LOB (PARAMETERS) STORE AS (DISABLE STORAGE IN ROW
                           CACHE
                           CHUNK 16384)
;

OM_DATA02_07 is created as follows:
CREATE TABLESPACE OM_DATA02_07 DATAFILE '/u08/oradata/VSAM/OM_DATA02_07_f01.dbf' SIZE 2000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M SEGMENT SPACE MANAGEMENT AUTO;

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