PLSQL Performance Tuning

Have Queries? Ask us +91 72592 22234

Course Overview

The PLSQL Performance Tuning presentation focuses on the advanced features of Oracle's PL/SQL and SQL features. Additionally, the performance and tuning issues are elaborated. Collections SPARSE collections Table functions BULK COLLECT Cursor variables Dynamic SQL Packages PL/SQL optimization Locking & concurrency Performance and good practices

Course Content

  • How PLSQL Optimizes your programs
  • When to tune PLSQL code ?
  • Guidelines for avoiding PLSQL Performance Problems
    • Avoiding CPU overhead in PLSQL code
    • Avoiding memory overhead in PLSQL code
  • Profiling and tracing PLSQL programs
    • Using the Profiler API : DBMS_PROFILER package
  • Overview
  • Security Model
  • Operational Notes
  • Exceptions
  • Using DBMS_TRACE package
    • Requirements, Restrictions, and constants for DBMS_TRACE.
    • Using DBMS_TRACE Package
    • Summary of DBMS_TRACE subprograms
  • Reducing the loop overhead for DML statements and queries
    • Using the FOR-ALL statement.
    • Retrieving the query results into collections with BULK COLLECT clause.
  • Writing computation intensive programs in PLSQL
  • Tuning Dynamic SQL with EXECUTE IMMEDIATE and Cursor variables.
  • Tuning PLSQL procedure calls with the NOCOPY compiler hint.
    • Restrictions on NOCOPY
  • Compiling the PLSQL code for Native Execution.
  • Setting up transformation pipelines with table functions.
    • Overview of table functions.
    • Using pipelined table functions for transformation.
    • Writing a pipelined table function.
    • Returning results from table function.
    • Pipelining data between PLSQL table functions.
    • Querrying table functions.
  • Optimizing multiple calls to table functions.
  • Fetching from the results of table functions.
  • Passing data with cursor variables.
  • Performing DML operations inside table functions.
  • Performing DML operations on table functions.
  • Handling exceptions in table functions.

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234