Forum Stats

  • 3,722,461 Users
  • 2,244,316 Discussions
  • 7,849,849 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Take Full Advantage of the PLSQL Compiler!

Comments

  • Akshs
    Akshs Member Posts: 70
  • Excellent summary doc - (aside from the sting of the missing reference to this forum as a resource on page 3!)

  • 3218565
    3218565 Member Posts: 47

    Good Document Steven

  • Steven Feuerstein-Oracle
    Steven Feuerstein-Oracle Member Posts: 136 Employee

    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
    Chris Hunt Member Posts: 2,066 Gold Trophy

    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
    Justin Warwick Member Posts: 103 Bronze Badge

    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
    Steven Feuerstein-Oracle Member Posts: 136 Employee

    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
  • Justin Warwick
    Justin Warwick Member Posts: 103 Bronze Badge

      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.

Sign In or Register to comment.