LIQUENT InSight 6.2 Installation Guide

Oracle Configuration Assistant Settings

When completing the Oracle Configuration Assistant wizard to create a database instance for LIQUENT InSight, use the following settings as directed.

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)
The following are suggested settings for improving performance depending on the system load in your environment. PAREXEL does not have metrics to provide, but informal testing has shown that these settings can improve performance.
  • sga_max_size = 1500MB   (Oracle scope=spfile)
  • sga_target = 1500MB
  • alter system set db_file_multiblock_read_count = 128 scope=BOTH;
  • alter system set optimizer_mode = ALL_ROWS scope=BOTH;
  • alter system set optimizer_index_caching = 100 scope=BOTH;

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.