dba_rewrite_equivalences shows rewrite equivalences. This view comes also in the other three variants user_rewrite_equivalences, all_rewrite_equivalences and cdb_rewrite_equivalences. select req.owner, req.name, req.source_stmt, req.destination_stmt, req.rewrite_mode from dba_rewrite_equivalences req;
dbms_advanced_rewrite.