Technical data

Configuration Guidelines
Database Implementation Guidelines 4-5
Database Syntax
SecureFile
CREATE TABLE <Table_Name>
( COLUMN1 ….,
COLUMN2 (CLOB)
)
LOB(COLUMN2) STORE AS SECUREFILE (CACHE COMPRESS);
CREATE TABLE <Table_Name>
( COLUMN1 ….,
COLUMN2 (CLOB)
CONTRAINT <> PRIMARY KEY(…)
)
ORGANIZATION INDEX PCTTHRESHOLD 50 OVERFLOW
LOB(COLUMN2) STORE AS SECUREFILE (ENABLE STORAGE IN ROW CHUNK CACHE
COMPRESS);
Database Initialization Parameters
The recommended Initialization Parameters are given below. These parameters are a starting point
for database tuning. An optimal value for a production environment may differ from one
customer deployment to another.
db_block_size=8192
log_checkpoint_interval=0
db_file_multiblock_read_count=8
transactions=3000
open_cursors=3000
db_writer_processes=12
optimizer_index_cost_adj=1
optimizer_index_caching=100
db_files=1024
dbwr_io_slaves=10 (Only if Asynchronous IO is not Supported)
sessions=4500
memory_target=0
memory_max_target=0
sec_case_sensitive_logon=FALSE
processes=3000
dml_locks=4860