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