IMPROVING PL/SQL PERFORMANCE IN
This presentation is the property of its rightful owner.
Sponsored Links
1 / 3

IMPROVING PL/SQL PERFORMANCE IN ORACLE APEX PowerPoint PPT Presentation


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.

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Improving pl sql performance in oracle apex

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.


Improving pl sql performance in oracle apex

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.


Improving pl sql performance in oracle apex

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.


  • Login