List Packages Compiled with Debug Information

SELECT owner, name, type FROM all_plsql_object_settings WHERE PLSQL_DEBUG='TRUE';