A SERVICE OF

logo

518 Appendix C
ITO Tables and Tablespaces in the Database
ITO Tables and Tablespace
opc_hist_
annotation
opc_hist_anno_
text
OPC_9 SIZE 4M
AUTOEXTEND ON NEXT 1M
MAXSIZE 500M
DEFAULT STORAGE (
INITIAL 2M
NEXT 2M
PCTINCREASE 0 )
Tables with
heavy load.
Indexes not on
the same disk
as table, thus
providing extra
tablespace.
Temporary data
(used for sorting)
OPC_TEMP SIZE 1M
AUTOEXTEND ON NEXT 1M
MAXSIZE 500M
DEFAULT STORAGE (
INITIAL 512K
NEXT 512K
PCTINCREASE 0 )
none
Index tablespace
for active
messages
OPC_INDEX1 SIZE 10M
AUTOEXTEND ON NEXT 1M
MAXSIZE 500M
DEFAULT STORAGE (
INITIAL 1M
NEXT 1M
PCTINCREASE 0 )
Other disk than
for opc_act_
messages
tablespaces.
Index tablespace
for history
messages
OPC_INDEX2 SIZE 10M
AUTOEXTEND ON NEXT 1M
MAXSIZE 500M
DEFAULT STORAGE (
INITIAL 1M
NEXT 1M
PCTINCREASE 0 )
Other disk than
for opc_hist_
messages
tablespaces.
Tables/
Description
Table-
space
Size Remarks