Is This Content Helpful?
We're glad to know this article was helpful.
What are appropriate values for the SDE DBTUNE parameter st_geom_lob_storage?
The ArcSDE DBTUNE parameter, st_geom_lob_storage, is used for defining the storage characteristics of the ST_Geometry attribute, the ST_Geometry points attribute's LOB segment storage, and the LOB's segment index.
The following example demonstrates a valid configuration string for the st_geom_lob_storage parameter, which defines the ST_Geometry attribute's storage characteristics, the point attribute's LOB segment storage characteristics, and the LOB's segment index storage characteristics.
ST_GEOM_LOB_STORAGE "STORE AS (
ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE
TABLESPACE users_data STORAGE (INITIAL 500M PCTINCREASE 10)
INDEX (TABLESPACE users_lob_idx STORAGE (INITIAL 50M PCTINCREASE 10)))"
Oracle recommends not to define the name of the LOB segment's index and storage clause as demonstrated above and in the ArcSDE dbtune file 'INDEX (TABLESPACE users_lob_idx STORAGE (INITIAL 50M PCTINCREASE 10))'. See the following knowledge base article: Should the Oracle LOB segment's index name be specified when creating an ST_Geometry attribute? for additional information.