Facets Demo New Batches Starting from Saturday... 22-10-2016
Search Course Here

Live Chat
Oracle Performence & Tuning  Online Training

Oracle Performence & Tuning


Performance tuning is a never-ending task for the DBA, and this learning guide can help newbies and experts establish a smart approach to tuning, use and interpret Oracle's tuning utilities and identify specific problem areas.
  • A general understanding of database administration
  • Skills and knowledge commensurate with Oracle's Database 11g: Administration Workshop I and Workshop II, or equivalent experience
  • Oracle Database 11g: Administration Workshop I - Self-Study Course
  • Oracle Database 11g: Administration Workshop II - Self-Study Course
  • It is a 20 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Introduction
    • Cause of Performance Problems
    • Setting Performance Goals
    • The Tuning Cycle
    • ORACLE Architecture
    • Logical Storage Structures
    • Physical Structures
    • Memory Structures
    • The Shared Pool
    • Processes
    • Some Administration Terminology
  • Design
    • Data Design Phase
    • Data Model Design
    • Online Transaction Processing
    • Decision Support Systems
    • Multi-purpose Applications
  • Optimizing SQL
    • Physical Retrieval of Data
    • Full Table Scan versus Index Reads
    • Performance Diagnostic Tools
    • Explain Plan
    • SQL Trace Facility
    • TKPROF
    • Autotrace
    • Join Methods
    • Sort/Merge Joins
    • Nested Loops
    • Hash Joins
    • Hash Join Example Data Access Methods
  • Indexes
    • Basic Indexes
    • B-Tree Indexes
    • Bitmap Index
    • Comparing B-Tree and Bitmap Indexes
    • Reverse Key Index
    • Index-Organised Tables
    • Invisible index
    • Creating Monitoring and Maintaining Indexes
  • Automatic SQL Tuning
    • Query Optimizer Modes Types of Tuning Analysis
    • Automatic workload repository SQL Tuning Advisor SQL Tuning Sets Top SQL
    • Identify high - load SQL Dynamic Performance views
  • SQL Performance Analyzer
    • Describe SQL Performance Analyzer process and benefits
    • Use SQL Performance Analyzer
  • The Optimizer
    • The ORACLE Optimizer
    • SQL statement parsing
    • Initialisation parameters
    • Rule Based Optimizer
    • Cost Based Optimizer
    • Rule / Cost Comparisons
    • Choosing an Approach
    • Multiple WHERE Clauses
    • Using Indexes for Sorts
    • Multiple Table Joins
    • Disabling Indexes
    • Sharing SQL Statements
    • Sharing Cursors
    • Sharing SQL Statements
    • Sharing Cursors
    • Adaptive Cursors Sharing
    • Other SQL Tuning Tips
  • Gathering Statistics
    • Analyzing Statistics
    • Automatic Optimizer Statistics Collection
    • Histograms
    • How to Generate Histograms Statistics
  • SQL Plan Management
    • SQL outlines
    • SQL profiles
    • SQL Access Advisor
    • Set up and use SQL plan baseline
  • Advanced Tuning
    • Star Queries
    • Materialized Views
    • Refreshing Views
    • Materialized View Logs
    • SQL Result Cache
    • Temporary Tables
  • Statistics and Wait Events
    • Identify dynamic performance views useful in tuning
    • Identify key tuning components of the alert log file
    • Identify key tuning components of user trace files
    • Use dynamic performance views to view statistics and wait events
  • Metrics, Alerts, and Baselines
    • View metrics using the metrics history views
    • Create metric thresholds
    • View alerts
    • Create metric baselines
    • Enable adaptive thresholds
  • Using Statspack
    • Install Statspack
    • Create Statspack snapshots
    • Generate Statspack reports
    • Identify the major sections of the Statspack report
  • Using Statspack
    • Create and manage AWR snapshots
    • Generate AWR reports
    • Create snapshot sets and compare periods
    • Generate ADDM reports
    • Generate ASH reports
Oracle Performence & Tuning videos will be updated soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Start From 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :