Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 10g > Oracle Database 10g: Advanced PL/SQL Programming & Tuning Training

Oracle Database 10g: Advanced PL/SQL Programming & Tuning Training

Course#: WA1382

The objective of this course is to allow experienced PL/SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed.

Objectives

Among the specific objectives to be met with this course are these:

  • Exploiting and managing cursor sharing.
  • Utilizing cursor variables.
  • Invoking external procedures.
  • Including dynamic SQL and other advanced programming techniques.
  • Efficiently executing dynamic SQL using bulk bind techniques.
  • Tuning with the DBMS_PROFILER() system-supplied package.
  • Debugging with the DBMS_TRACE() system-supplied package.
  • Performance tuning and analysis of PL/SQL applications

Prerequisites

Mandatory prerequisites for this course are the following courses:

  • The course Oracle Database 10g: Introduction to SQL - Complete Library
  • The course Oracle Database 10g: Program With PL/SQL - Complete Library

Audience

The target audience for this course is senior application developers. Developers who will be building, debugging and tuning PL/SQL program units will benefit from this course.

Duration

Four days.

Outline of WA1382 Oracle Database 10g: Advanced PL/SQL Programming & Tuning Training

1. PL/SQL DEVELOPMENT SUPPORT FROM EM 

  • ABOUT EM & PL/SQL
  • MANAGING INVALID OBJECTS  

2. EXPLOITING & MANAGING CURSOR SHARING 

  • ABOUT CURSOR SHARING
  • BIND VARIABLES & CURSOR PEEKING
  • USING THE CURSOR_SHARING PARAMETER  

3. DYNAMIC SQL 

  • NATIVE DYNAMIC SQL  

4. USING COLLECTIONS

  • ABOUT COLLECTIONS
  • BULK BIND USING COLLECTIONS
  • COLLECTION METHODS

5. RETRIEVING DDL WITH DBMS_METADATA()

  • WHY RETRIEVE OBJECT DEFINITIONS?
  • RETRIEVING DEFAULT METADATA
  • RETRIEVING CUSTOMIZED METADATA

6. ADVANCED DBMS_METADATA() PROCESSING

  • SET_TRANSFORM_PARAM()
  • GET_QUERY()

7. PROCESSING DEPENDENT OBJECTS WITH DBMS_METADATA()

8. REDEFINING TABLES WITH DBMS_REDEFINITION()

  • ABOUT TABLE REDEFINITION
  • USING THE DBMS_REDEFINITION() PACKAGE

9. USING OTHER SYSTEM-SUPPLIED PACKAGES

  • DBMS_DESCRIBE()
  • UTL_MAIL
  • DBMS_SCHEDULER()

10. USING LARGE OBJECTS (LOBS)

11. ADVANCED INTERFACE METHODS

  • ABOUT EXTERNAL PROCEDURES
  • REGISTERING WITH THE DATABASE
  • ORACLE NET CONFIGURATION
  • CALLING EXTERNAL PROCEDURES

12. ABOUT PL/SQL PERFORMANCE TUNING

  • ABOUT THE TUNING EFFORT
  • THE DIFFICULTY OF TUNING
  • THE SQL & PL/SQL EXECUTION ENVIRONMENT
  • THE IMPACT OF THE SYSTEMS INFRASTRUCTURE

13. USING THE TUNING UTILITIES

14. INFLUENCING ORACLE10G PL/SQL COMPILATION

  • PLSQL_WARNINGS
  • PLSQL_OPTIMIZE_LEVEL
  • PL/SQL NATIVE EXECUTION

15. PL/SQL TUNING WITH DBMS_PROFILER()

  • ABOUT DBMS_PROFILER()
  • INSTALLING DBMS_PROFILER()
  • USING DBMS_PROFILER() TO MANAGE RUNS
  • EXAMINING THE PROFILER TABLES

16. EVALUATING THE PL/SQL PROFILER DATA

  • ABOUT THE PROFILER DATA
  • USER QUERIES OF THE CROSS RUN TABLES
  • SYSTEM-SUPPLIED CROSS RUN TABLES QUERIES

17. PL/SQL ADVANCED PROGRAMMING & TUNING TECHNIQUES

  • AUTONOMOUS TRANSACTIONS
  • USING NOCOPY FOR PARAMETERS
  • CHOOSING THE OPTIMUM DATATYPE
  • USEFUL PL/SQL CODING TECHNIQUES

18. PL/SQL DEBUGGING WITH DBMS_TRACE()

  • ABOUT THE TRACE FACILITY
  • INSTALLING DBMS_TRACE()
  • USING DBMS_TRACE() TO MANAGE RUNS
  • EXAMINING THE PLSQL_TRACE_... TABLES
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.