UCP connection.close Does Not Clear ClientId, Module, Action Attributes In V$SESSION Using connection.setClientInfo Method (Doc ID 2487572.1)

Last updated on JULY 21, 2023

Applies to:

Symptoms

On : 12.2.0.0.0 version, Thin JDBC driver

ACTUAL BEHAVIOR
---------------
When setting CLIENTID, MODULE, ACTION to null before closing JDBC UCP connection and returning to connection pool, the attributes are not reset in V$SESSION view.

This causes issues with tools that report data based on these attributes such as OEM, as well as when using DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE and DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE procedures. For example, when resetting the attributes to null and returning to the connection pool, tracing should automatically be disabled for the session if set using DBMS_MONITOR. However, since these attributes are not reset, this does not occur. In addition, monitoring tools will display incorrect information because the attributes still exist in V$SESSION though the connection is really not actively being used to carry out work for the related CLIENTID, MODULE, ACTION.

EXPECTED BEHAVIOR
-----------------------
It is expected to have those properties be set to null.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use the next java program:

Executing the above after the attributes have been set to null and the connection returned to the pool will show that CLIENTID, ACTION, MODULE are still set for the session.

Changes

Cause

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