Configuring Session Settings in the Database Instance Settings

Previous TopicNext TopicContents

The session settings allow you to issue database statements to customize the database environment when the connections are created. You need to set these settings only if you have a customization you need to apply to a database environment.

To set your session settings:

  1. Open the P6 Administrator application.
  2. In the Configurations tab, expand your configuration.
  3. Expand Database/Instance[n]/Session Settings.
  4. In the Setting [n] field, enter the commands used to establish cursor sharing, rule-based mode, SQL trace, and more when database connections are created. Invalid settings in these fields are ignored. You can create five session settings.

    Oracle Example:

    alter session set _ = _

    Microsoft SQL Server Example:

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Related Topics

About Database Instance Settings

Configuring Driver Class and URL for Database Instance Settings

Configuring User Security for Database Instance Settings

Configuring Connection Pool for Database Instance Settings

Configuring Oracle Webcenter Content Core Capabilities Database Settings

Configuring Microsoft SharePoint in the Database Instance Settings

Configuring CMIS-Compliant Content Repository in the Database Instance Settings

Configuring the Oracle Database Content Repository

Configuring Cost Based Optimization Settings in the Database Instance Settings

Configuring Eventing in the Database Instance Settings

Configuring AIA in the Database Instance Settings

Configuring Fusion Projects Settings in the Database Instance Settings

Configuring BI Publisher in the P6 Administrator application

Configuring P6 to Connect to Oracle BPM 11g



Legal Notices
Copyright © 1999, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, July 29, 2015

PDF Library