Enable code optimization technique using PLSQL_OPTIMIZE_LEVEL

Attribution: This article is a complimentary excerpt from Oracle Advanced PL/SQL Developer Professional Guide Oracle initialization parameter PLSQL_OPTIMIZE_LEVEL The parameter was introduced in Oracle 10g to decide the level of optimization applicable for a program unit during compilation. The optimization during compilation means the removal of dead code, code movements to optimize iterative constructs, inline… Read More Enable code optimization technique using PLSQL_OPTIMIZE_LEVEL

Check out “Invisible indexes” on Oracle Community

Oracle Community The social network for Oracle people Saurabh Gupta Check out the blog post ‘Invisible indexes’Hi, View my latest publication.. http://www.exforsys.com/tutorials/oracle-11g/oracle-11g-invisible-index.html Do post your feedback !! Blog post link: Invisible indexes About Oracle Community For anyone interested in Oracle databases, applications and related technologies.   8655 members 486 photos 67 videos 948 discussions 212… Read More Check out “Invisible indexes” on Oracle Community