SQL & PL/SQL

Nice document

Excellent summary doc - (aside from the sting of the missing reference to this forum as a resource on page 3!)

Good Document Steven

Excellent summary doc - (aside from the sting of the missing reference to this forum as a resource on page 3!)

Hmmm. That is a very good point, rp0428! I have corrected my mistake and uploaded a new version. Thanks!

Could you enlarge on the points made on Page 8? An example or two would be helpful in understanding what you're trying to say.

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.

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

  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.