beautypg.com

HP UX B6941-90001 User Manual

Page 517

background image

Appendix C

517

ITO Tables and Tablespaces in the Database

ITO Tables and Tablespace

Default
tablespace of user
opc_op

OPC_5

SIZE 1M
AUTOEXTEND ON NEXT 1M
MAXSIZE 500M

DEFAULT STORAGE (

INITIAL 32K
NEXT 32K
PCTINCREASE 0 )

none

opc_hist_messages

OPC_6

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.

opc_hist_msg_text

OPC_7

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.

opc_hist_orig_text

OPC_8

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.

Tables/

Description

Table-

space

Size

Remarks