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 logs
  2 disks	Windows 2008	Oracle INFORM SYSTEM Study Tables Redo logs	Study Indexes TEMPBIG Redo logs UNDOTBS Archive logs
  3 disks	Windows 2008	Oracle INFORM SYSTEM Redo logs	Study Indexes TEMPBIG Redo logs UNDOTBS Archive logs	Study Tables
  4 disks	Windows 2008	Oracle INFORM SYSTEM Redo logs	TEMPBIG Redo logs UNDOTBS Archive logs	Study Tables	Study Indexes
  5 disks	Windows 2008	Oracle SYSTEM Redo logs	INFORM Redo logs UNDOTBS	Study 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, 2016 Oracle and/or its affiliates. All rights reserved.