open database exclusive

[TomazZ]

This will list you all users and roles that have restricted session privilege

select s.grantee, r.grantee grantee_through_role
  from dba_sys_privs s,
       dba_role_privs r
 where s.privilege='RESTRICTED SESSION'
   and r.granted_role (+) = s.grantee