VIEW: SYS.DBA_XS_SESSION_ROLES

Source

View Text - Preformatted

select sid, rolename
    from sys.rxs$session_roles
   where bitand(roleflags,1) = 1 with read only

View Text - HTML Formatted

SELECT SID
, ROLENAME
FROM SYS.RXS$SESSION_ROLES
WHERE BITAND(ROLEFLAGS
, 1) = 1 WITH READ ONLY