I really don’t believe that there is an easy way to determine that. I have attempted a similar process in the past. The issue that I had was dynamic SQL statements being built, along with embedded SQL statements. The only shorthand method that I was able to use to find duplication of SQL statements within PL/SQL was to do a string search on the various from clauses. To find possible identical statements and then manually compare them from there. Hope this helps.