 |
|
|
Oracle 9i PL/SQL Application Tuning
This 4-day course demonstrates how to write efficient and tuned programs. Performance techniques, problem areas and troubleshooting tolls are all presented.
 Course Summary:
- Understanding Tuning Issues
- Using TKPROF & AUTOTRACE
- Using the STATSPACK Utility
- Exploiting & Managing Cursor Sharing
- Using Cursor Variables
- Invoking External Procedures
- Advanced Program Units
- Using Collections
- PL/SQL Tuning with DBMS_PROFILER()
- Evaluating the PL/SQL: PROFILER Data
- PL/SQL Tuning Techniques
- PL/SQL Debugging with DBMS_TRACE()
Follow-Up Courses:
Option of other related or follow-on courses:
- OracleTM 9i Fundamentals
- OracleTM SQL Introduction
- OracleTM Intro to PL/SQL Language
- OracleTM SQL Advanced
|
 |
|
|
