DBA_XS_SESSION_ROLES

The DBA_XS_SESSION_ROLES dynamic data dictionary view lists application roles enabled in application sessions.

Column Datatype NULL Description
SESSIONID RAW(16) NOT NULL Application session ID
ROLE VARCHAR2(128) NOT NULL Name of the application role