Take Full Advantage of the PLSQL Compiler!

Steven Feuerstein-Oracle

Akshs

Nice document

Unknown

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

3218565

Good Document Steven

Steven Feuerstein-Oracle

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!

Chris Hunt

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.

Justin Warwick

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.

Steven Feuerstein-Oracle

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

Justin Warwick

  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.