Optimizing BLOB storage parameters
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;