Oracle 12c SQL Tuning for Developers

This course will introduce the developer to techniques used to provide minimize response times in and Oracle database.

    Dec 21 2020

    December 21 - 23, 2020 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live

    Date: 12/21/2020 - 12/23/2020 (Monday - Wednesday) | 8:30 AM - 4:30 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.

    REQUEST MORE INFO:


    Oracle 12c SQL Tuning for Developers

    December 21 - 23, 2020 | 8:30 AM - 4:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

1. Subqueries

  • Where Clause Subqueries
  • From Clause Subqueries
  • Correlated Subqueries
  • Scalar Subqueries
  • Exists Subqueries
  • Tree-Structured queries

2. Overview of the Tuning Environment

  • Performance Tuning Duties
  • Steps for Tuning
  • Tuning Methodology
  • The Tuning Team
  • Tuning Tools

3. Tune Database Operations

  • SQL Parsing and Execution
  • Shared SQL Statements
  • The SQL Area
  • Automatic Segment Space Management
  • Statement Transformation
  • Using SQL Syntax

4. Tuning the Logical Structure

  • Tuning Overview
  • Tablespace Considerations
  • Table Considerations
  • Free Space Management
  • Chaining and Migrated Data
  • Choosing the Right Index
  • Index Usage Monitoring
  • Materialized Views

5. SQL Tuning Tools

  • Optimizer Overview
  • Execution Plans
  • Rule-Based Optimization (Desupported)
  • Cost-Based Optimization
  • Table and Index Statistics
  • DBMS_STATS
  • Execution Plans
  • Autotrace
  • SQL_TRACE and TKPROF
  • Using Hints
  • Stored Outlines and Plan Stability

6. Application Memory Use

  • Memory Tuning Goals
  • Tuning the Buffer Cache
  • Memory Subcaches
  • Partitioned Tables and Indexes

7. PL/SQL Packages for the Tuner

  • DBMS_PROFILER
  • DBMS_SESSION
  • DBMS_TRACE
  • DBMS_STATS

8. Performance Tuning Checklist

  • Data Model Review
  • Object Management
  • Architectural Issues
  • Shared Pool
  • Buffer Cache
  • File I/O
  • Redo Log Buffer and Checkpoints
  • Sort Activity
  • Write faster, more efficient code by optimizing SQL statements and the Oracle architecture

Application developers and database administrators who need a fundamental understanding of tuning the Oracle architecture and SQL statements

Ready to Advance Your Career?

CONTACT US NOW!