Table c-1 ito tables and tablespaces in an oracle – HP UX B6941-90001 User Manual
Page 516

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