Database Query Tuning Training Course Content

Spread the love

Database Query Tuning Training Course Content Details

What is Database Query Tuning

Database question standardization. … it always overlaps with question standardization, however refers to style of the info files, choice of the direction system (DBMS) application, and configuration of the database’s setting (operating system, CPU, etc.).
Database standardization describes a gaggle of activities accustomed optimize and homogenize the performance of a info. it always overlaps with question standardization, however refers to style of the info files, choice of the direction system (DBMS) application, and configuration of the database’s setting (operating system, CPU, etc.).Database query tuning training in hyderabad kukatpally

Database standardization aims to maximise use of system resources to perform work as expeditiously and chop-chop as potential. Most systems ar designed to manage their use of system resources, however there’s still abundant area to boost their potency by customizing their settings and configuration for the info and also thepackage.
DBMS standardization refers to standardization of the package and also the configuration of the memory and process resources of the pc running the package. this can be usually done through configuring the package, however the resources concerned ar shared with the host system.

Tuning the package will involve setting the recovery interval (time required to revive the state of knowledge to a selected purpose in time), distribution similarity (the breaking apart of labor from one question into tasks assigned to completely different process resources), and network protocols accustomed communicate with infoshoppersfor more info click here.

Database Query Tuning Course Content


  • Course Objectives
  • Course Organization
  • Course Agenda
  • Topics Not Included in the Course
  • Who Tunes?
  • What Does the DBA Tune?
  • How to Tune
  • Tuning Methodology

02.Basic Tuning Diagnostics

  • Performance Tuning Diagnostics, Features, and Tools
  • DB Time
  • CPU and Wait Time Tuning Dimensions
  • Time Model
  • Dynamic Performance Views
  • Statistics
  • Wait Events
  • Log Files and Trace Files

03.Using Automatic Workload Repository

  • Automatic Workload Repository Overview
  • Automatic Workload Repository Data
  • Enterprise Manager Cloud Control and AWR
  • Snapshots
  • Reports
  • Compare Periods

04.Defining the Scope of Performance Issues

  • Defining the Problem and Limiting the Scope
    Top SQL Reports
  • Common Tuning Problems
  • Tuning During the Life Cycle
  • ADDM Tuning Session
  • Performance Tuning Resource
  • Monitoring and Tuning Tools Overview

05.Using Metrics and Alerts

  • Metrics and Alerts Overview
  • Limitation of Base Statistics
  • Benefits of Metrics
  • Viewing Metric History Information
  • Viewing Histograms
  • Server-Generated Alerts
  • Setting Thresholds
  • Metrics and Alerts Views

06.Using Baselines

  • Comparative Performance Analysis with AWR Baselines
  • Moving Window Baseline
  • Baseline Templates
  • Creating AWR Baselines
  • Baselines Views
  • Performance Monitoring and Baselines
  • Defining Alert Thresholds Using a Static Baseline
  • Configuring Adaptive Thresholds

07.Using AWR-Based Tools

  • Automatic Maintenance Tasks
  • ADDM Performance Monitoring
  • Active Session History
  • Additional Automatic Workload
  • Repository Views
  • Real-time ADDM

08.Real-Time Database Operation Monitoring

  • Overview and Use Cases
  • Defining a Database Operation
  • Database Operation Concepts
  • Enabling Monitoring of Database Operations
  • Identifying, Starting, and Completing a Database Operation
  • Monitoring the Progress of a Database Operation
  • Database Operation Views
  • Database Operation Tuning

09.Monitoring Applications

  • Service Attributes and Types
  • Creating Services
  • Using Services with Client Applications
  • Using Services with the Resource Manager
  • Services and Oracle Scheduler
  • Services and Metric Thresholds
  • Top Services Performance Page

10.Identifying Problem SQL Statements

  • SQL Statement Processing Phases
  • SQL Monitoring
  • Execution Plans
  • DBMS_XPLAN Package
  • EXPLAIN PLAN Command
  • Reading an Execution Plan
  • Using the SQL Trace Facility
  • Generating an Optimizer Trace

11.Influencing the Optimizer

  • Functions of the Query Optimizer
  • Optimizer Statistics
  • Controlling the Behavior of the Optimizer by Using Parameters
  • Enabling Query Optimizer Features
  • Using Hints
  • Access Paths
  • Join Operations
  • Sort Operations

12.Reducing the Cost of SQL Operations

  • Index Maintenance
  • SQL Access Advisor
  • Table Maintenance and Reorganization
  • Extent Management
  • Data Storage
  • Migration and Chaining
  • Shrinking Segments
  • Table Compression

13.Using SQL Performance Analyzer

  • SQL Performance Analyzer Overview
  • Real Application Testing Overview and Use Cases
  • Capturing the SQL Workload
  • Creating a SQL Performance Analyzer Task
  • Comparison Reports
  • Tuning Regressing Statements
  • Guided Workflow Analysis
  • SQL Performance Analyzer Views

14.SQL Performance Management

  • Maintaining Optimizer Statistics
  • Automated Maintenance Tasks
  • Statistics Gathering Options and Preferences
  • Deferred Statistics Publishing
  • Automatic SQL Tuning
  • SQL Tuning Advisor
  • SQL Access Advisor
  • SQL Plan Management

Database Query Training Demo

Contact Us for Database Query Online and classroom Training

venkat: 9059868766
email:[email protected]
Address: PlotNo 126/c,2nd floor,Street Number 4, Addagutta Society, Jal Vayu Vihar, Kukatpally, Hyderabad, Telangana 500085

Sharing is caring!

Updated: May 12, 2017 — 4:31 am

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.