beautypg.com

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

Page 516

background image

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