Learning Objectives : This chapter provides an introduction to performance tuning scenarios and its tools.

Topics Include :

• Oracle Performance Tuning Tools
• Monitoring tools overview
• Enterprise Manager
• V$ Views, Statistics and Metrics
• Wait Events

Practicals Covered : Here, candidates get a knowledge regarding tuning Oracle Database tutorial for performance.

Learning Objectives : Explore and collect the performance statistics on usages of Automatic Workload Repository.

Topics Include :

• Managing the Automatic Workload Repository Create AWR Snapshots
• Oracle Performance Tuning Techniques
• Real-Time SQL Monitoring

Practicals Covered : Users here learn about the AWR features and reports.

Learning Objectives : Tuning system to tailor and define problems and way to resolve them by best meeting your business needs.

Topics Include :

• Defining the Problem
• Limit the Scope & Setting the Priority
• Top SQL Reports
• Common Tuning Problems & Tuning During the Life Cycle
• ADDM Tuning Session
• Performance Versus Business Requirements
• Performance Tuning Resources & Filing a Performance Service Request
• Monitoring and Tuning Tools: Overview

Practicals Covered : Candidates learn to tune in the system planning and define problems at different phases. 

Learning Objectives : A built-in alerts infrastructure to notify usage of metrics and ways to manage it.

Topics Include : 

• Metrics, Alerts, and Baselines
• Limitation of Base Statistics & Typical Delta Tools
• Oracle Database 11g Solution: Metrics
• Benefits of Metrics
• Viewing Metric History Information & using EM to View Metric Details
• Statistic Histograms & Histogram Views
• Database Control Usage Model & Setting Thresholds
• Server-Generated Alerts, Creating and Testing an Alert & Metric and Alert Views.

Practicals Covered : Prospects learn to use performance metrics and alerts to detect usual functionalities and changes if any.

Learning Objectives : This chapter will explain how to manage SQL Plan baselines-including selecting and evolving baselines. 

Topics Include :

• Comparative Performance Analysis with AWR Baselines
• Automatic Workload Repository Baselines
• Moving Window Baseline
• Baselines in Performance Page Settings & Baseline Templates
• AWR Baselines & Creating AWR Baselines
• Managing Baselines with PL/SQL & Baseline Views
• Performance Monitoring and Baselines & Defining Alert Thresholds Using a Static Baseline
• Using EM to Quickly Configure & Changing Adaptive Threshold Settings.

Practicals Covered : Candidates learn to capture the baselines along with some derived examples.

Learning Objectives : This module lays focus on application of AWR based tools depending on its investigation derived. 

Topics Include :

• Automatic Maintenance Tasks
• ADDM Performance Monitoring
• Active Session History: Overview

Practicals Covered : Prospects explore the chances of applications of tools within several scenarios. 

Learning Objectives : This module lays strong foundation on how to learn to monitor and access the overall performance of an application.

Topics Include :

• What Is a Service? Service Attributes & Service Types
• Creating Services & Managing Services in a Single-Instance Environment
• Everything Switches to Services.
• Using Services with Client Applications & Using Services with the Resource Manager
• Services and Resource Manager with EM & Using Services with the Scheduler
• Using Services with Parallel Operations & Metric Thresholds
• Service Aggregation and Tracing & Service Aggregation Configuration.
• Client Identifier Aggregation and Tracing & Service Performance Views.

Practicals Covered : Candidates learn the usage of monitoring the application performance in real time. 

Learning Objectives : This chapter discusses goals for identifying problem SQL statements. 

Topics Include :

• SQL Statement Processing Phases & Role of the Oracle Optimizer
• Identifying Bad SQL, Real Time SQL Monitoring & TOP SQL Reports
• What Is an Execution Plan? Methods for Viewing Execution Plans & Uses of Execution Plans
• DBMS_XPLAN Package: Overview & EXPLAIN PLAN Command
• Reading an Execution Plan, Using the V$SQL_PLAN View & Querying the AWR
• SQL*Plus AUTOTRACE & SQL Trace Facility
• How to Use the SQL Trace Facility
• Generate an Optimizer Trace

Practicals Covered : Students here learn way of identifying and troubleshooting problems within SQL statements.

Learning Objectives : This section holds information regarding adequate Optimizer defaults for majority of operations. 

Topics Include : 

• Functions of the Query Optimizer, Selectivity, Cardinality and Cost & Changing Optimizer Behaviour
• Using Hints, Optimizer Statistics & Extended Statistics
• Controlling the Behaviour of the Optimizer with Parameters
• Enabling Query Optimizer Features & Influencing the Optimizer Approach
• Optimising SQL Statements, Access Paths & Choosing an Access Path
• Join & Sort Operations
• How the Query Optimizer Chooses Execution Plans for Joins
• Reducing the Cost.

Practicals Covered : Prospects here explore the ways to tune the optimizer for a specific type of workload and influence it further to provide better performance. 

Learning Objectives : The chapter covers the concepts of SQL tuning sets with the SQL Performance Analyzer. 

Topics Include :

• Real Application Testing: Overview & Use Cases
• SQL Performance Analyzer: Process & Capturing the SQL Workload
• Creating an SQL Performance Analyzer Task & SPA (NF Lesson 9) DBMS_SQLTUNE.CREATE_TUNING_TASK
• Optimizer Upgrade Simulation & SQL Performance Analyzer Task Page
• Comparison Report & Comparison Report SQL Detail
• Tuning Regressing Statements & Preventing Regressions
• Parameter Change Analysis & Guided Workflow Analysis
• SQL Performance Analyzer: PL/SQL Example & Data Dictionary Views.

Practicals Covered : Users can now analyze the performance of the statements either major or minor in a SQL Performance Analyzer.

Learning Objectives : In this course, candidates are introduced to diagnosis of performance management and its related issues.

Topics Include : 

• Maintaining SQL Performance and Optimizer Statistics & Automated Maintenance Tasks
• Statistics Gathering Options & Setting Statistic Preferences
• Restore Statistics
• Deferred Statistics Publishing: Overview & Example
• Automatic SQL Tuning: Overview
• SQL Tuning Advisor: Overview
• Using the SQL Access Advisor
• SQL Plan Management: Overview

Practicals Covered : Candidates here learn about the performance analysis and tuning tasks expected out of a DBA. 

Learning Objectives : This chapter typically explains how to replay a database workload on the test system.

Topics Include : 

• The Big Picture & System Architecture
• Capture & Replay Considerations
• Replay Options & Analysis
• Database Replay Workflow in Enterprise Manager
• Packages and Procedures
• Data Dictionary Views: Database Replay
• Database Replay: PL/SQL Example
• Calibrating Replay Clients

Practicals Covered : Candidates here can explore about the replay system that is running the same version of Oracle Database.

Learning Objectives : This chapter explains how to tune the shared pool and the large pool. 

Topics Include :

• Shared Pool Architecture & Operation
• The Library Cache & Latch and Mutex
• Diagnostic Tools for Tuning the Shared Pool
• Avoiding Hard & Soft Parses
• Sizing the Shared Pool & Avoiding Fragmentation
• Data Dictionary Cache & SQL Query Result Cache
• UGA and Oracle Shared Server
• Large Pool & Tuning the Large Pool.

Practicals Covered : Users learn about the management of shared pool and large pool to manually apply the tuning process.

Learning Objectives : This chapter describes how to tune the database buffer cache.

Topics Include : 

• Oracle Database Architecture: Buffer Cache
• Database Buffers
• Buffer Hash Table for Lookups
• Working Sets
• Buffer Cache Tuning Goals and Techniques
• Buffer Cache Performance Symptoms & Solutions
• Automatically Tuned Multiblock Reads
• Flushing the Buffer Cache (for Testing Only).

Practicals Covered : Users learn to manage the database memory on individual systems and learn to manually tune the memory caches.

Learning Objectives : This chapter discusses about basics of tuning the PGA. 

Topics Include : 

• SQL Memory Usage & Performance Impact
• SQL Memory Manager
• Configuring Automatic PGA Memory & Setting PGA_AGGREGATE_TARGET Initially
• Monitoring & Tuning SQL Memory Usage
• PGA Target Advice Statistics & Histograms
• Automatic PGA and Enterprise Manager & Automatic PGA and AWR Reports
• Temporary Tablespace Management: Overview & Monitoring Temporary Tablespace
• Temporary Tablespace Shrink & Tablespace Option for Creating Temporary Table.

Practicals Covered : Firstly, candidates learn about the scenario when PGA is tuned manually and how the problems can be resolved under automatic tuning.

Learning Objectives : This section provides background information on Automatic Memory Management feature. 

Topics Include : 

• Oracle Database Architecture, Dynamic SGA & Memory Advisories
• Granule & Manually Adding Granules to Components
• Increasing the Size of an SGA Component, SGA Sizing Parameters & Manually Resizing Dynamic SGA Parameters
• Automatic Shared Memory Management & Memory Broker Architecture
• Behaviour of Auto-Tuned & Manually Tuned SGA Parameters
• Using the V$PARAMETER View & Resizing SGA_TARGET
• Disabling, Configuring & Monitoring Automatic Shared Memory Management (ASMM)
• Automatic Memory Management.

Practicals Covered : Candidates are enabled with the instructions for executing the AMM feature of Oracle Database.

Learning Objectives : This chapter contains an overview of the Oracle methodology for configuring a database for performance.

Topics Include :

• Space and Extent Management & Locally Managed Extents
• How Table Data Is Stored & Anatomy of a Database Block
• Minimize Block Visits
• The DB_BLOCK_SIZE Parameter
• Small & Large Block Size: Considerations
• Block Allocation, Free Lists & Block Space Management with Free Lists
• Automatic Segment Space Management
• Migration and Chaining, Shrinking Segments & Table Compression: Overview.

Practicals Covered : Candidates here learn to execute performance modifications to Oracle Database on an ongoing process. 

Learning Objectives : This chapter explains how to avoid Input/Output bottlenecks that could prevent Oracle from performing at its maximum potential.

Topics Include : 

• I/O Architecture, File System Characteristics, I/O Modes & Direct I/O
• Bandwidth Versus Size & Important I/O Metrics for Oracle Databases
• I/O Calibration and Enterprise Manager, I/O Calibration and the PL/SQL Interface & I/O Statistics and Enterprise Manager
• Stripe and Mirror Everything
• Using RAID
• I/O Diagnostics
• Database I/O Tuning
• What Is Automatic Storage Management?

Practicals Covered : Prospects learn to tune I/O to enhance performance of a disk that contains database files and which is operating at its capacity.

Learning Objectives : This chapter lays focus on most efficient and effective way to Optimize an Oracle database and tune their layers.

Topics Include :

• Best practices identified throughout the course
• Summarise the performance tuning methodology.

Practicals Covered : Here, users are introduced to performance tuning features and its tools.