|
|
|
|
Distributed InForm study tablespaces
In a production environment, Oracle recommends distributing tablespaces across multiple disks. The table in this topic presents a suggested model for Microsoft Windows database servers. For Linux database servers, the disk and partition names would follow the naming conventions for those environments.
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 the default temporary tablespace of BIGFILE type 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 2012
Oracle
INFORM
SYSTEM
Study Tables
Study Indexes
TEMPBIG
Redo logs
UNDOTBS
Archive logs2 disks
Windows 2012
Oracle
INFORM
SYSTEM
Study Tables
Redo logsStudy Indexes
TEMPBIG
Redo logs
UNDOTBS
Archive logs3 disks
Windows 2012
Oracle
INFORM
SYSTEM
Redo logsStudy Indexes
TEMPBIG
Redo logs
UNDOTBS
Archive logsStudy Tables
4 disks
Windows 2012
Oracle
INFORM
SYSTEM
Redo logsTEMPBIG
Redo logs
UNDOTBS
Archive logsStudy Tables
Study Indexes
5 disks
Windows 2012
Oracle
SYSTEM
Redo logsINFORM
Redo logs
UNDOTBSStudy Tables
Study Indexes
TEMPBIG
Archive logs
