V$XS_SESSION_ROLE

V$XS_SESSION_ROLE displays information about the enabled roles for all lightweight user sessions in the database as of the end of the last request. The security context of active requests is not reflected in this view.

Column Datatype NULL Description
NAME VARCHAR2(4000) NOT NULL Role name
ROLEID NUMBER(10) NOT NULL Role Internal ID
UUID RAW(16) NOT NULL Role ID
LWSID RAW(16) NOT NULL Lightweight session ID