Udemyintermediatept

PL/SQL Tuning

Master PL/SQL code optimization. Improve performance and efficiency with expert techniques. Learn to write faster, cleaner PL/SQL.

4.8(13)
32students
1h 50m
Certificate
Fábio H. N. D. Prado
Fábio H. N. D. PradoDBA/Instrutor Oracle ACE

Course Content

PL/SQL Tuning is an intermediate-level Udemy course taught by Fábio H. N. D. Prado. It runs 1h 50m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 13 reviews, with 32 students enrolled. It is a paid course, first published June 2016.

Optimize Your PL/SQL Code: 30+ Tips & Tricks

Unlock the full potential of your PL/SQL code with these practical optimization techniques. Learn how to write faster, more efficient, and maintainable database code.

  • Profiling with DBMS_TRACE: Master the DBMS_TRACE package to pinpoint performance bottlenecks. Analyze execution times for PL/SQL blocks and individual SQL statements within them. Understand how long your SQL queries take to run.

  • Data Types for Performance: Discover the most performant numeric data types for your PL/SQL applications, considering different compilation modes. Choose the right data type for optimal speed.

  • DBMS_SHARED_POOL Optimization: Learn how to effectively utilize the DBMS_SHARED_POOL package to pin objects and improve performance by keeping frequently used code in memory.

  • Leveraging the RETURNING Clause: Optimize your stored procedures by using the RETURNING clause for efficient data retrieval and reduced round trips.

  • Hint NOCOPY for Large Objects: Improve the performance of functions and procedures handling large collections (e.g., arrays, nested tables) with the NOCOPY hint.

  • Functions vs. Procedures: Choosing the Right Tool: Understand when to use functions for code reuse versus procedures for performance, making informed decisions for your PL/SQL design.

  • Dynamic SQL: Balancing Flexibility and Performance: Learn when dynamic SQL is appropriate and how to use it efficiently, weighing code brevity against potential performance impacts.

  • Bind Variables: A Performance Booster: Utilize bind variables effectively to avoid SQL injection vulnerabilities and improve performance by reusing execution plans.

  • Native Compilation: Speeding Up Execution: Explore native compilation and learn when and how to use it to significantly accelerate PL/SQL code execution.

  • Function Result Cache: Improving Efficiency: Discover the power of the Function Result Cache to store and reuse function results, reducing redundant computations.

  • Pipelined Table Functions: Efficient Data Processing: Learn how to use Pipelined Table Functions for efficient data processing and transformation within your PL/SQL workflows.

  • Bulk Binding: Optimizing Data Inserts/Updates: Implement bulk binding techniques to dramatically improve the performance of data insertion and update operations.

  • CURRENT OF Clause: Optimizing Update/Insert Logic: Effectively use the CURRENT OF clause to optimize PL/SQL blocks that update data based on IF/UPDATE/INSERT scenarios.

  • When to Avoid PL/SQL: SQL Pure for Speed: Identify situations where using pure SQL is more efficient than PL/SQL, leading to faster execution.

  • Deterministic Functions: Predictable Performance: Understand the benefits of deterministic functions and how to use them to ensure consistent and predictable performance.

  • Short-Circuit Evaluation: Optimizing Logic: Utilize short-circuit evaluation in your PL/SQL code to improve efficiency and avoid unnecessary computations.

  • Stored Procedures: Modularizing Transactions: Learn how to use stored procedures to encapsulate and optimize complex transactions, improving code organization and reusability.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

4.7(10,872)
32h 12m
beginner

Oracle SQL Tuning Índices

by Valter José de Aquino

4.6(341)
3h 58m
intermediate

Linguagem PLSQL Oracle

by Professor Braga Professor Braga

4.6(41)
7h 31m
intermediate

ORACLE SQL TUNING BÁSICO

by Valter José de Aquino

4.4(723)
3h 26m
beginner
4.4(442)
12h 42m
beginner