1 / 3

IMPROVING PL/SQL PERFORMANCE IN ORACLE APEX

It’s very easy to write PL/SQL in Oracle Application Express but it will degrade the performance of the Application because of a compilation of PL/SQL at runtime.<br>Keep the volume of code inside the Oracle Application Express application to a minimum. The simplest tuning technique to improve performance is to encapsulate PL/SQL within packages.<br>

Abacasys
Download Presentation

IMPROVING PL/SQL PERFORMANCE IN ORACLE APEX

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IMPROVING PL/SQL PERFORMANCE IN ORACLE APEX It’s very easy to write PL/SQL in Oracle Application Express but it will degrade the performance of the Application because of a compilation of PL/SQL at runtime. Keep the volume of code inside the Oracle Application Express application to a minimum. The simplest tuning technique to improve performance is to encapsulate PL/SQL within packages. This applies to any PL/SQL processes on page, plug-in, dynamic actions, validations, computations and dynamic PL/SQL.This change improves the execution time of PL/SQL as it’s processed at compile time instead of being parsed and compiled at runtime. Plug-ins can be wonderful black boxes and consumers may not care how it works or looks under the hood. You can always improve the performance of a plug-in by shifting the supplied code into a PL/SQL package.

  2. Move the code from the source of the Move the code from the source of the plug-in as a procedure in a package, perhaps in a package, perhaps plugin_util. Then change the “Render function name” Then change the “Render function name” to plugin_util.screen_saver_vik. _util.screen_saver_vik.

  3. Benefits of moving PL/SQL within packages: 1. Faster execution of Apex pages. 2. Less PL/SQL compilation at runtime. 3. Code is more maintainable and reusable. 4. Apex application export files are smaller – faster to deploy.

More Related