Take Full Advantage of the PLSQL Compiler!

Is there a way, after compilation, to detect what level of optimization was used? Perhaps you have something already in production, and you just want to find some candidates for recompile (but not necessarily any changes in the source) with increased optimization level.

  SELECT p.plsql_optimize_level

     FROM user_plsql_object_settings p

WHERE name = 'MY_OBJECT'

or find all the program units that are NOT compiled at level 2 or higher:

SELECT *

   FROM user_plsql_object_settings p

   WHERE p.plsql_optimize_level < 2

Thank you. Exactly what I was hoping for. And thanks to the engineers, wherever they are, who put this level of detail into the data dictionary. I never cease to be impressed and surprisded by the treasure in there.