beautypg.com

HP UX B6941-90001 User Manual

Page 518

background image

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