Determining which Oracle database session is being used by a specific Siebel user session (Doc ID 863771.1)

Last updated on JULY 10, 2023

Applies to:

Purpose

This document will explain a procedure that may be used to associate a specific Oracle database session from the V$SESSION table with a specific Siebel user session.  This is typically done to troubleshoot specific issues (for example a database process that is using unusually high resources) or to support levels of user auditing not currently available through the Siebel user interface.

The need for this kind of procedure is especially important if using LDAP or Active Directory (ADSI) authentication with shared database credentials.  When implementing the LDAPSecAdpt or ADSISecAdpt it is common to used a single shared database account for all Siebel users.  This greatly reduces the amount of administrative overhead since you do not have to maintain accounts in the Siebel application, the external directory, and the database server.

The problem with using shared database credentials, however, is that all Siebel user sessions appear as the same user at the database level.  This makes it difficult -- if not impossible -- to match a specific database session with a specific Siebel user session.

Although less of an issue when database authentication is being used with the DBSecAdpt, there are some instances when this procedure might still be helpful.  In particular, situations where the same user has logged in multiple times or where a shared userID is being utilized by an outside system through Siebel Enterprise Application Integration (EAI).

Scope

This reference document is intended for system administrators and database administrators working with the Siebel application and Siebel OLTP database.  Individuals attempting to utilize this procedure must have adequate rights on both the Oracle database server and the Siebel application.  Furthermore, basic Oracle SQL knowledge is required.

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.