Acrobat X Files

Home > Programming > Oracle Programming

Oracle PL/SQL Language

Sort Desciption:

Named Program Units | 69. The optimizing compiler (Oracle Database 10g). PL/SQLs optimizing compiler also introduced in Oracle. Database 10g can improve ...

Content Inside:

Oracle PL/SQL LanguagePage 1Steven Feuerstein Bill Pribyl & Chip DawesOraclePL/SQLLanguagePocket ReferenceA Guide to Oracles PL/SQL Language Fundamentals3rd EditionCovers Oracle Database 10gPage 2Named Program Units | 69The optimizing compiler (Oracle Database 10g)PL/SQLs optimizing compiler also introduced in OracleDatabase 10g can improve runtime performance dramatically while imposing only a relatively slight overhead at compile time. Fortunately the benefits of optimization apply toboth interpreted and natively compiled PL/SQL becauseoptimizations are applied by analyzing patterns in sourcecode.The optimizing compiler is enabled by default in OracleDatabase 10g. However you may want to alter its behaviorby either lowering its aggressiveness or disabling it entirely.For example if in the course of normal operations your system must perform recompilation of many lines of code or ifan application generates many lines of dynamically executedPL/SQL the overhead of optimization may be unacceptable.Note however that Oracles tests show that the optimizerdoubles the runtime performance of computationally intensive PL/SQL.In some cases the optimizer may even alter program behavior. One such case might occur in code written for Oracle9ithat depends on the relative timing of initialization sectionsin multiple packages. If your testing demonstrates such aproblem yet you want to enjoy the performance benefits ofthe optimizer you may want to rewrite the offending code orintroduce an initialization routine that ensures the desiredorder of execution.To change the optimizer settings for the entire database setthe database parameter PLSQL_OPTIMIZE_LEVEL. Validsettings are:0 No optimization1 Moderate optimization such as eliminating superfluouscode or exceptionsPage 370 | Oracle PL/SQL Language Pocket Reference2 (default)Aggressive optimization beyond level 1 includingrearranging source codeYou can also modify these settings for the current session; forexample:ALTER SESSION SET ...

Source: www.oreilly.com

 

Related Files

Oracle Database 10g: Program with PL/SQL

Filed under: Programming and Oracle Programming
Oracle Database 10g: Program with PL/SQL. Duration 5 Days. What you will learn. This class is applicable to Oracle8i Oracle9i and Oracle Database 10g users ...

Oracle JDeveloper for Forms & PL/SQL Developers; A Guide to J2EE ...

Filed under: Programming and Oracle Programming
The most efficient way to learn J2EE programming techniques. Two Oracle experts ... Market. Developers currently using Oracle Forms and the PL/SQL language ...

Oracle/SQL Tutorial

Filed under: Programming and Oracle Programming
C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition) AddisonWesley ... Oracle Data Dictionary. 23. 4. Application Programming. 4.1. PL/SQL ...

Oracle PLSQL Programming

Filed under: Programming and Oracle Programming
ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...

Oracle 10 g : Java Programming

Filed under: Programming and Oracle Programming
Oracle 10g: Java Programming. Duration 5 Days. What you will learn:. This course teaches the concepts and essential elements of the Java language. ...