Multiple study tablespaces

By default, all study objects are created in the INFORM tablespace. In a production environment, you should distribute each study across multiple tablespaces for improved performance and for maintenance and monitoring. Before you install your study on a production server, set up the study-specific tablespaces.

The following table lists the Oracle table and index tablespaces to create, along with the required parameters. All tablespaces should be locally managed.

Note: When creating the study tablespaces, use the names listed in the following table.

Study tablespaces for distributed environments

Table tablespace	Index tablespace	Size (MB)
%STUDY_NAME%_REF	%STUDY_NAME%_REF_IDX	120
%STUDY_NAME%_HIGH_TXN1	%STUDY_NAME%_HIGH_TXN1_IDX	300
%STUDY_NAME%_HIGH_TXN2	%STUDY_NAME%_HIGH_TXN2_IDX	500
%STUDY_NAME%_HIGH_TXN3	%STUDY_NAME%_HIGH_TXN3_DX	600
%STUDY_NAME%_HIGH_TXN4	%STUDY_NAME%_HIGH_TXN4_IDX	500
%STUDY_NAME%_TXN	%STUDY_NAME%_TXN_IDX	250

The remaining syntax for each of these tablespaces is:

AUTOEXTEND ON NEXT 50M
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

Note: The STUDY_NAME portion of the tablespace name must conform to Oracle database name standards. It cannot start with a numeric character and cannot contain special characters. Additionally, because the Oracle database has an internal limit of 30 characters for a tablespace name, the study name must be 16 characters or fewer.

Oracle provides sample configurations for distributing your tablespaces using from one to five disks.