 |
|
Oracle Tips by Burleson |
PL/SQL Tuning and Tracing
This tutorial introduces the PL/SQL array
processing with tables and shows the basic techniques for tuning and
tracing PL/SQL programs.
Within the topic of tuning PL/SQL, we explore
the Oracle 10g compiled PL/SQL and show how it can run 8 to 10 times
fasted than standard, interpreted PL/SQL. We will also look at tuning
PL/SQL data access techniques, and show how the ref cursor and bulk
collect techniques reduce the context switching between Oracle and
PL/SQL.
It is critical to remember that the primary
goal of all database tending is the reduction of disk I/O. Whether
were are tuning an SQL statement, a PL/SQL stored procedure, or an
entire Oracle instance, the primary goal is to configure the RAM
memory within the Oracle database SGA region in order to minimize the
expensive disk I/O operations.
Learning Outcomes
Upon completion of this tutorial, you will be
able to:
* Analyze Oracle database program performance
* Tune access methods to compiled code
* Tune data access methods
* Use bulk collect operations
* Use the FORALL operator in PL/SQL
* Trace the execution of PL/SQL
For more details, see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
|
