7.3. Configuring PL/SQL for Better Performance
There are several great features that PL/SQL gives a developer to fine-tune their code and prepare it for promotion to production. But like many development-oriented features, they may not be appropriate for production or may need to be disabled to support legacy code. The database initialization parameters that affect PL/SQL performance include:
PLSQL_WARNING
PLSQL_DEBUG
PLSQL_OPTIMIZE_MODE
PLSQL_CODE_TYPE
NOTE
For advanced tuning of PL/SQL programs, see the white paper "PL/SQL Just Got Faster" by Bryn Llewellyn and Charles Wetherell. It is located on the Oracle Technet website. At the time of publication, the URL was www.oracle.com/technology/tech/pl_sql/htdocs/New_In_10gR1.htm.
PL/SQL compiler ...
Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
