Oracle has many settings that a DBA can modify after implementation. PAREXEL does not test every possible configuration scenario. Unless otherwise noted, the Oracle database settings are assumed to be standard out-of-the-box settings at the time of installation. As the size of database grows and additional information becomes available, PAREXEL understands that some database settings may need to be adjusted by your DBA to optimize performance.

Required Settings

• redo log size = 500M
• undo tablespace must be adequately sized: If you are running a supported version of Oracle (see LIQUENT InSight 6.2 SSD), confirm you are using the auto management of the undo tablespace.
• database character set = Unicode (AL32UTF8)
• national character set = UTF8 (Unicode 3.0 UTF-8 Universal character set)
• connection mode = Dedicated Server Mode
• workarea_size_policy = AUTO
• the default tablespace users must be created before installing LIQUENT InSight
• a TEMP tablespace must be created in Optional settings
• set instance connections to (see show parameters sessions below)

Establish the maximum number of Oracle sessions you would like to make available for LIQUENT InSight use. This value may be directly tied to the maximum number of users you will have working on your system. The current session count can be determined by keying the following command into the SQL command line:

• show parameters sessions;

If the current setting is deemed too small, please consult with your DBA to increase this value. Retain this value for use when setting up your LIQUENT InSight Application Server.