Oracle: Special synonyms for dome data dictionary views

select
   synonym_name,
   table_name
from
   dba_synonyms
where
   table_owner  = 'SYS'          and
   regexp_like(table_name, '^(USER_|ALL_|DBA_)') and
   table_name <> synonym_name
order by
   synonym_name;