A SERVICE OF

logo

516 Appendix C
ITO Tables and Tablespaces in the Database
ITO Tables and Tablespace
Table C-1 ITO Tables and Tablespaces in an Oracle Database
Tables/
Description
Table-
space
Size Remarks
opc_act_messages OPC_1 SIZE 4M
AUTOEXTEND ON NEXT 6M
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.
opc_anno_text
opc_annotation
opc_msg_text
opc_orig_ msg_text
OPC_2 SIZE 5M
AUTOEXTEND ON NEXT 6M
MAXSIZE 500M
DEFAULT STORAGE (
INITIAL 1M
NEXT 1M
PCTINCREASE 0 )
Tables with
heavy load.
Indexes not on
the same disk
as table, thus
providing extra
tablespace.
opc_node_names OPC_3 SIZE 1M
AUTOEXTEND ON NEXT 1M
MAXSIZE 500M
DEFAULT STORAGE (
INITIAL 256K
NEXT 256K
PCTINCREASE 0 )
Table with very
frequent access.
All other tables OPC_4 SIZE 20M
AUTOEXTEND ON NEXT 1M
MAXSIZE 500M
DEFAULT STORAGE (
INITIAL 32K
NEXT 256K
PCTINCREASE 0 )
none