Do you believe that, challenging task of an Oracle DBA is “Performance Tuning”? It is not so. Be the competitor and become reputed Oracle DBA engineer today. This course is designed specially to focus on all the key areas of performance tuning to the real time DBA’s. Performance tuning skill is MUST for every professional to excel in the domain of Oracle Database Administration. This course will concentrate on training you on both theoretical concepts and activities with our focused approach. With the systematic model, on Single Instance database environment you will be skilled to crack any performance issue on any environment.

Get Real time hands-on experience on “Performance Tuning” now.

  • Install and Implement yourself.
  • Simple and easy to understand.
  • Meet industry standards.

System requirements:

  • Laptop/Desktop with at least 3GB RAM.
  • Minimum of Dual Core processor.
  • 40 GB of disk space.

Training details:

  • 25 Sessions.
  • Trainer: Pawan Kumar Yaddanapudi.
  • Includes supporting documents, software’s and Log files.
  • Anytime assistance.

Demo Video:

Pick your mode of learning:

Video tutorials:

  • Learn at your own pace.
  • Saves 50% of your money.
  • Revise any number of times for 6 months.
  • Assured quality and content as classroom/online training.

Online training:

  • One scheduled session per day.
  • Good internet connectivity required.
  • Batch of minimum 5 students.

Click Here for Online Training Schedule

Course Content

1. ORACLE DATABASE ARCHITECTURE – TUNING CENTRIC
1.1 Software functionality
1.2 OS dependencies
1.3 Background processes – To concentrate
1.4 Storage and Memory dependencies
2. PERFORMANCE TUNING TOOLS
2.1 Explain plan of SQL statements
2.2 Tracing SQL execution
2.3 tkprof for trace analysis
2.4 AUTOTRACE in SQL*
2.5 V$ dynamic performance views
2.6 OEM
2.7 AWR, ADDM and ASH reports
2.8 SQL tuning advisor and baselines
2.9 OS monitoring
3. ORACLE OPTIMIZER
3.1 Basics of Optimizer
3.2 Understanding behaviour
3.3 Histograms and Bind Peeking
3.4 Access paths
3.5 Interpreting JOINS
3.6 Optimizer statistics
3.7 Hints
3.8 Manage Optimizer
4.SQL TUNING WITH ACTIVITIES- 1
4.1.Thumb rules
4.2.Possible SQL issues
4.3.SQL Tuning methods and Tools
4.4.Pro-active SQL Tuning
4.5.Reactive SQL Tuning
4.6.Real-Time Tuning Examples
5.SQL TUNING WITH ACTIVITIES – 2
5.1.SQL tuning examples (Continue)
5.2.Creating SQL tuning sets and baselines
5.3.Tuning JOINS
5.4.Sorting and Grouping activities
5.5.PL/SQL tuning notes
5.6.Parallelism in SQL
6.REAL TIME DATA LOADING AND MONITORING
6.1.Creating SCHEMAS, TABLES
6.2.Preparing Environment
6.3.Load Data-1
6.4.Monitor using OEM & Alert log
6.5.Load Data-2
6.6.Monitor using V$ views
7.REAL TIME – AWR REPORT ANALYSIS
7.1.Preparing environment
7.2.Load Data-3
7.3.Generate AWR reports
7.4.Analysis & Problem Identification
7.5.Fixing Performance Issue
8.REPORTS & ANALYSIS
8.1.AWR reports and baselines
8.2.ADDM reports
8.3.ASH report
8.4.Exercise on AWR, ADDM & ASH REPORTS
8.5.Optimizer tracing and analysis
8.6.Tracing levels and options
8.7.Exercise on Optimizer tracing
9.DATABASE STORAGE OBJECTS
9.1.Storage options
9.2.Oracle Partitioning
9.3.Star schema design
9.4.Partitioning Examples
9.5.Indexes Overview
9.6.B-Tree Indexes & Examples
9.7.BitMap Indexes & Examples
9.8.Index Organized Tables & Examples
10.ADVISORIES
10.1.BAD SQL tracing & Analysis
10.2.SQL tuning Advisor
10.3.STS (SQL Tuning Set) with SQL tuning advisor
10.4.SQL Access advisor
10.5.Implementing SQL Plan management
10.6.Fragmentation and Data distribution
11.INSTANCE/MEMORY REAL TIME TUNING
11.1.Shared pool tuning – Latch/Mutex, Library cache, Cursors
11.2.Shared pool tuning – Parses, Result cache, Data dictionary
11.3.Real time Activity – Shared pool Tuning
11.4.Buffer cache tuning – TitBits
11.5.Real time Activity – Buffer cache Tuning
11.6.PGA tuning and Sort area – Titbits
11.7.Automatic memory management – Concepts
11.8.Real time Activity – PGA Tuning
12.I/O TUNING
12.1.Oracle I/O Architecture
12.2.Disk I/O concepts
12.3.Monitoring Oracle I/O
12.4.All about RAID
12.5.Tuning I/O – Options
12.6.ASM solutions
13.BEST ARCHITECTURAL PRACTICES
13.1.Important parameters
13.2.Stograge considerations
13.3.Memory size planning
13.4.High Availability – Best practices
13.5.Maintenance
13.6.Top WAIT Events
13.7.Application analysis
13.8.Pro-active monitoring approach
13.9.Monitoring tools in place