This script will show invalid database objects such as packages, proceedures, functions, views and triggers. It will only output objects that are marked invalid.


SELECT object_type, object_name
FROM dba_object
WHERE status = 'INVALID';


To recompile all invalid objects see my script to automate this.

*Cupertino, CA & Portsmouth, NH* �- November 14, 2006 — MySQL AB, developer of the world’s most popular open source database, and NitroSecurity, a provider of high performance and scalable enterprise security solutions, today announced they have signed a strategic agreement to jointly develop and market a database engine for MySQL(r) based on NitroSecurity’s NitroEDB� extreme performance relational database technology. Read more here : http://www.mysql.com/news-and-events/news/article_1181.html