I'm unclear what you mean by the "status" of the role, but dba_roles, dba_role_privs, dba_application_roles might be worth looking at.