How to Show CLIENT INFO and CLIENT IDENTIFIER from Sql Plus (v$session), Which has Populated in APEX Database Monitor (Doc ID 2174616.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0.0.00 and later
Information in this document applies to any platform.

Goal

 Client information and client identifier columns populated from APEX database monitor, but using a tool like SQL*plus or SQL Developer and querying the database for the same session those columns are not populated.

Solution

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