Hello,

I want put table in cache , I have 50 simultanous session on this table,
what is the optimal value of db_keep_cache_size ?


CREATE TABLE COMPANY_PROFILE
(
COMPANY_NAME VARCHAR2(50 BYTE),
PARAMETER_NAME VARCHAR2(30 BYTE),
PARAMETER_VALUE VARCHAR2(80 BYTE),
FLEX_FLD1 VARCHAR2(256 BYTE),
FLEX_FLD2 VARCHAR2(256 BYTE),
FLEX_FLD3 VARCHAR2(256 BYTE),
FLEX_FLD4 VARCHAR2(256 BYTE),
FLEX_FLD5 VARCHAR2(256 BYTE)
)
TABLESPACE TABST01
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 640K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL KEEP
)
LOGGING
NOCACHE
NOPARALLEL;

Oracle LazyDBA home page