Answer
Use the Application Monitoring Console — it has a dedicated view for exactly this, listing invalid objects (including custom ones) without needing to write or maintain a custom query against USER_OBJECTS/DBA_OBJECTS yourself.
Use the Application Monitoring Console — it has a dedicated view for exactly this, listing invalid objects (including custom ones) without needing to write or maintain a custom query against USER_OBJECTS/DBA_OBJECTS yourself.
← Browse Developer Studio, deployment, and upgrades questions