Mail :
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-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 14th DEC & 15th DEC.

Hadoop Dev New Batch Start From 15th DEC & 16th DEC.

IBM COGNOS TM New Batch Start From 16th DEC & 17th DEC.

Informatica Dev New Batch Start From 17th DEC & 18th DEC.

Mean Stack New Batch Start 18th DEC & 19th DEC.

SAP BODS new Batch Starting From 19th DEC & 20th DEC.

SAP S/4 HANA New Batch Start From 20th DEC & 21st DEC

Tableau New Batch Start From 21st DEC & 22nd DEC


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th DEC & 07:00A.M IST on 14th DEC

Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :