1. System Administration Guide
  2. Correlating Database Sessions

Correlating Database Sessions

The Object Manager Parameter Enable Database Session Correlation (EnableDbSessCorrelation) allows the Siebel Application to correlate a database connection with the database session created for the user.

When the database connection is created, this parameter logs the User Id that is associated with the connection allowing you to trace the connection’s use by that user.

This is particularly useful when users report performance issues. You can look through the log to find the database session id associated with the user reporting the issue and find problematic SQL. You can also correlate user activity by querying V$SESSION so that you can see what a session is doing, including its current SQL, wait events, and resource consumption. This is valuable for DBAs and performance analysts.

The following table describes EnableDbSessCorrelation Settings.

Parameter Name Value Description

EnableDbSessCorrelation

TRUE

The Database Session Id for a Connection will be logged.

EnableDbSessCorrelation

FALSE (Default)

No additional information will be logged.

The logging statements in the application log appears like this:

  • Shared Connection Id: xxx

  • Transaction Connection Id: yyyy

  • "DataBase Connection Object was created at %x; DB User: '%s'"