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.