|
|
|
|
Distributed InForm study tablespaces
In a production environment, Oracle recommends distributing tablespaces across multiple disks. This table presents a suggested model. In each configuration, it is recommended that you use the C: partition for the operating system and distribute the database and application components across the remaining partitions. Monitor your system to determine the optimal configuration.
- C: and D: are partitions on one disk.
- INFORM, SYSTEM, TEMPBIG are tablespaces.
Note: TEMPBIG is a temp tablespace and the default temporary storage location for the InForm application.
Distributed tablespace examples
Physical disks
0
1
2
3
4
Logical disks
C:
D:
E:
F:
G:
H:
1 disk
Windows 2008
Oracle
INFORM
SYSTEM
Study Tables
Study Indexes
TEMPBIG
Redo logs
UNDOTBS
Archive logs2 disks
Windows 2008
Oracle
INFORM
SYSTEM
Study Tables
Redo logsStudy Indexes
TEMPBIG
Redo logs
UNDOTBS
Archive logs3 disks
Windows 2008
Oracle
INFORM
SYSTEM
Redo logsStudy Indexes
TEMPBIG
Redo logs
UNDOTBS
Archive logsStudy Tables
4 disks
Windows 2008
Oracle
INFORM
SYSTEM
Redo logsTEMPBIG
Redo logs
UNDOTBS
Archive logsStudy Tables
Study Indexes
5 disks
Windows 2008
Oracle
SYSTEM
Redo logsINFORM
Redo logs
UNDOTBSStudy Tables
Study Indexes
TEMPBIG
Archive logs
Note: For a Linux database server, the disk and partition names would follow the naming conventions for those environments.
Copyright © 2014, 2017 Oracle and/or its affiliates. All rights reserved.