Oracle PL/SQL Training In Chennai Adyar With Placement - Greens

Sponsored Ads

Price: Check with seller

SQL Statement Tuning Training Course ContentExploring the Oracle Database ArchitectureDescribe the major architectural c...

  • Category: Language Classes
  • Published: 30/10/2014
  • Current Rating: /5 0 Vote


    SQL Statement Tuning Training Course Content

    Exploring the Oracle Database Architecture

    • Describe the major architectural components of Oracle Database server

    • Explain memory structures

    • Describe background processes

    • Correlate logical and physical storage structures

    Introduction to SQL Tuning

    • Describe what attributes of a SQL statement can make it perform poorly

    • Describe the Oracle tools that can be used to tune SQL

    • Explain the tuning tasks

    Introduction to the Optimizer

    • Describe the execution steps of a SQL statement

    • Explain the need for an optimizer

    • Explain the various phases of optimization

    • Control the behavior of the optimizer

    Interpreting Execution Plans

    • Gather execution plans

    • Display execution plans, display xplan

    • Interpret execution plans

    Application Tracing

    • Configure the SQL Trace facility to collect session statistics

    • Use the trcsess utility to consolidate SQL trace files

    • Format trace files using the tkprof utility

    • Interpret the output of the tkprof command

    Optimizer Operations

    • Describe the SQL operations for tables and indexes

    • Describe the possible access paths for tables and indexes

    Optimizer: Join Operations

    • Describe the SQL operations for joins

    • Describe the possible access paths for joins

    Other Optimizer Operations

    • Describe Clusters, In-List, Sorts, Filters and Set Operations

    • Use Result Cache operations

    Case Study: Star Transformation

    • Define a star schema, a star query plan without transformation and a star query plan after transformation

    Optimizer Statistics

    • Gather optimizer statistics

    • Gather system statistics

    • Set statistic preferences

    • Use dynamic sampling

    • Manipulate optimizer statistics

    Using Bind Variables

    • Explain the benefits of using bind variables

    • Use bind peeking

    • Use adaptive cursor sharing

    SQL Tuning Advisor

    • Describe statement profiling

    • Use SQL Tuning Advisor

    Using SQL Access Advisor

    • Use SQL Access Advisor

    Automating SQL Tuning

    • Use Automatic SQL Tuning

    SQL Plan Management

    • Manage SQL performance through changes

    • Set up SQL Plan Management

    • Set up various SQL Plan Management scenarios

    Using Optimizer Hints

    • Use hints when appropriate

    • Specify hints for Optimizer mode, Query transformation, Access path, Join orders, Join methods and Views

    Parallel Queries

    Parallel Processing Concepts

    • Explain what parallel processing is and why is it useful

    Basics of Parallel Execution

    • Describe operations that can be parallelized

    • Explain parallel execution theory

    • Understand impact of initiali zation parameter on parallel execution

    Manual DOP Management

    • Understand an explain plan of a parallel query

    • Understand an explain plan of parallel DML and DDL

    Simplified Auto DOP

    • Understand the new parameters of Auto DOP

    • Explain when to use Auto DOP

    • Use Auto DOP

    Statement Queuing

    • Explain statement queuing, concurrency and DBRM

    In-Memory Parallel execution

    • Use in-memory parallel execution

    Data Warehouse Administration

    Partitioning Concepts

    • Explain the available partitioning strategies

    • Explain partition pruning

    • Implement partition enhancements in star query optimization

    Materialized Views

    • Use summaries to improve performance

    • Differentiate materialized view types

    Phone Number : 8939915577

    Related Ads

    Leave your comment

    Copyright © 2016 |   All Rights Reserved | |   24x7 support |   Email us: query[at]