Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Take Full Advantage of the PLSQL Compiler!

Comments
-
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.