When Using Xdb Webservices Column Program In V$Session Is Not Populated (Doc ID 1231155.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


There is a session in the database which comes from an XDB Web service connection and querying view V$SESSION expecting to see something in the column PROGRAM in view V$SESSION for such connection but there is no value. It is NULL for the column PROGRAM in V$SESSION.

Sessions are identified in V$SESSION with PROGRAM column

SQL> select program, sid from v$session;

PROGRAM                                          SID
------------------------------------------------ ----------
oracle@celclnx7.us.oracle.com (GEN0)                      1
oracle@celclnx7.us.oracle.com (DIA0)                      2
oracle@celclnx7.us.oracle.com (CKPT)                      3
.
.
oracle@celclnx7.us.oracle.com (MMON)                    190
sqlplus@celclnx7.us.oracle.com (TNS V1-V3)              191

20 rows selected.


In the case of the connections made from XDB web services the PROGRAM column is empty. (not shown)

Cause

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