How to Populate CLIENT_INFO and CLIENT_IDENTIFIER into V$session using JDBC and UCP (Doc ID 2287242.1)

Last updated on JULY 20, 2017

Applies to:

JDBC - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Goal

 While the PROGRAM column in v$session is easily populated using a connection property, this is not the case for CLIENT_INFO And CLIENT_IDENTIFIER.

 

For example:

 

 Using the above method will successfully populate the PROGRAM column, however the CLIENT_INFO And CLIENT_IDENTIFIER will be left blank.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms