Distributed Oracle 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 Oracle InForm application.

Physical disks	0	N/A	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 logs	N/A	N/A	N/A	N/A
2 disks	Windows 2012	Oracle INFORM SYSTEM Study Tables Redo logs	Study Indexes TEMPBIG Redo logs UNDOTBS Archive logs	N/A	N/A	N/A
3 disks	Windows 2012	Oracle INFORM SYSTEM Redo logs	Study Indexes TEMPBIG Redo logs UNDOTBS Archive logs	Study Tables	N/A	N/A
4 disks	Windows 2012	Oracle INFORM SYSTEM Redo logs	TEMPBIG Redo logs UNDOTBS Archive logs	Study Tables	Study Indexes	N/A
5 disks	Windows 2012	Oracle INFORM SYSTEM Redo logs	INFORM Redo logs UNDOTBS	Study Tables	Study Indexes	TEMPBIG Archive logs