My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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