8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Automatic Subprogram Inlining in Oracle Database 11g Release 1

Pierre said...

Hi Tim,

great explain. Thanks. It is a best practice to always inline fonctions and procedure?

so always set the PLSQL_OPTIMIZE_LEVEL to 3 in a Database is a best practice? Or is there any consequences?



Tim... said...


I would never set it for the database. I would only set it for individual objects I have identified would benefit from it.



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.