beautypg.com

Ito tables and tablespace – HP UX B6941-90001 User Manual

Page 515

background image

Appendix C

515

ITO Tables and Tablespaces in the Database

ITO Tables and Tablespace

ITO Tables and Tablespace

An Oracle database uses tablespaces to manage the available disk space.
You can assign datafiles of a fixed size to tablespaces. The size of the
various datafiles assigned to a tablespace determines the size of the
tablespace.

To increase the size of a tablespace, you must add a datafile of a
particular size to the tablespace. You can do this interactively using the
Oracle tool, Server Manager, or using the

sql

command:

alter

tablespace add datafile

. Table C-1 on page 516 shows the default

tablespace design and the assigned database tables.

For more information about improving the performance of your database
see the online documentation in:

/opt/OV/ReleaseNotes/opc_db.tuning