Setup Of CLIENT_INFO Column In V$Session For JDBC Connections

(Doc ID 742308.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Communications Order and Service Management - Version 2.5.2 to [Release 2.5 to 7.3.0]
Information in this document applies to any platform.
Reviewed relevance on July 07, 2014, Dec 08, 2015, May 9, 2017


This note shows the steps to set up the CLIENT_INFO column in the V$SESSION view, so that the JDBC connections from the oms_pool can be easily identified. It is recommended to follow this note after a successful OSM installation, as it is helpful for database related troubleshooting.


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