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.| 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:
CREATE TABLESPACE TABLESPACE_NAME
DATAFILE ‘<path_to_data_file>’ SIZE <initial_size>
AUTOEXTEND ON NEXT <file_increment>
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.