* Learn the basics of
* See how to tune calls to the Oracle database.
* Use PL/SQL arrays and
internal tables to speed-up processing.
* Understand PL/SQL
tracing and debugging.
* Use ref cursors and bulk
collect for fast performance.
* See how to improve PL/SQL performance by
replacing complex SQL with intermediate arrays.
* Learn how to compile
This BC Oracle PL/SQL programming & Tuning
Training class is an
intense course that is designed to give the student
maximum exposure to Oracle PL/SQL tuning and performance optimization.
The student learns by example, studying actual performance case studies.
The PL/SQL tuning class topics start with the basic
performance tuning and progress into increasingly complex tuning techniques, including
bulking, optimizing calls to Oracle and using ref cursors. We guarantee
your success via our optional PL/SQL mentoring and the students will gradually
masters PL/SQL through increasingly challenging classroom
||Oracle PL/SQL Tuning
Expert Secrets for High Performance Programming
Dr. Tim Hall
This PL/SQL tuning training course is designed for practicing Oracle PL/SQL
professionals who have basic experience with PL/SQL and the use of a
procedural language. Prior experience with PL/SQL is not required,
but experience with a relational database is highly