PLSQL Performance Tuning

• Course Overview
• Course Content
• Customer Reviews

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

---

---

---

...more