Configuring Session Settings in the Database Instance Settings

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:

Open the Primavera P6 Administrator.
In the Configurations drop-down list, select your configuration.
In the sidebar select Database.
Select your Instance from the drop-down list.
Expand Session Settings.
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 or Oracle Autonomous Database Example:

alter session set _ = _

Microsoft SQL Server Example:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Note: Changes to this setting require you to restart the P6 server.

Related Topics