My Oracle Support Banner

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.