VIEW: SYS.V$XS_SESSION_ROLE

Source

View Text - Preformatted

select rolename, roleintid, roleid, sid
    from xs$session_roles where roleflags = 1 with read only

View Text - HTML Formatted

SELECT ROLENAME
, ROLEINTID
, ROLEID
, SID
FROM XS$SESSION_ROLES
WHERE ROLEFLAGS = 1 WITH READ ONLY