When Using Xdb Webservices Column Program In V$Session Is Not Populated
(Doc ID 1231155.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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.
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
In the case of the connections made from XDB web services the PROGRAM column is empty. (not shown)
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