• admin@thetechmaster.in
  • |
  • +919676516545

admin@thetechmaster.in

+919676516545

Oracle Performance tuning

Faculity Name : Kumar

Experience : 7 Years

Course Duration : 20 days

Price : 17000 INR

Course Details

  • About Course
  • About Instructor
  • Course Content
  • Videos

Oracle performance tuning is one of the core areas where always a need for expertise. This course helps you to analyze various performance issues in your environment and able to resolve them successfully.

Pre-requisite: Good knowledge on Oracle DBA

Training Highlights:

Test environment Database will be loaded with Scripts to generate the Load on the Database

More Detail analysis on AWR Report,SQL Tunning Advisor,SQL Access Advisor from SCRATCH level...ETC

How to tune SQL query, what are possible SQL issues in every database.

Scripts will be handed over to candidate in order to replicate in their local machines

Detail material will be provided

Kumar

Experience : 7 Years

Kumar is having 7 years experience and working as Sr Oracle DBA in an MNC with core expertise in performance tuning, Dataguard and Goldengate.

He is having 6 years of training experience and handles training for performance tuning, Oracle DBA, Dataguard, RAC and Goldengate courses.

Oracle Performance tuning Course Content

Oracle Performance Tuning

Course Content

PERFORMANCE TUNING TOOLS

  • Explain plan of SQL statements
  • Tracing SQL execution
  • tkprof for trace analysis
  • AUTOTRACE in SQL*
  • V$ dynamic performance views
  • AWR, ADDM and ASH reports
  • SQL tuning advisor and baselines
  • OS monitoring

ORACLE OPTIMIZER

  • Basics of Optimizer
  • Understanding behaviour
  • Histograms and Bind Peeking
  • Access paths
  • Interpreting JOINS
  • Optimizer statistics
  • Hints
  • Manage Optimizer

SQL TUNING WITH ACTIVITIES- 1

  • Thumb rules
  • Possible SQL issues
  • SQL Tuning methods and Tools
  • Pro-active SQL Tuning
  • Reactive SQL Tuning
  • Real-Time Tuning Examples

 

SQL TUNING WITH ACTIVITIES – 2

  • SQL tuning examples (Continue)
  • Creating SQL tuning sets and baselines
  • Tuning JOINS
  • Sorting and Grouping activities
  • PL/SQL tuning notes
  • Parallelism in SQL

REAL TIME DATA LOADING AND MONITORING

  • Creating SCHEMAS, TABLES
  • Preparing Environment
  • Load Data-1
  • Monitor using OEM & Alert log
  • Load Data-2
  • Monitor using V$ views

REAL TIME – AWR REPORT ANALYSIS

  • Preparing environment
  • Load Data-3
  • Generate AWR reports
  • Analysis & Problem Identification
  • Fixing Performance Issue

REPORTS & ANALYSIS

  • AWR reports and baselines
  • ADDM reports
  • ASH report
  • Exercise on AWR, ADDM & ASH REPORTS
  • Optimizer tracing and analysis
  • Tracing levels and options
  • Exercise on Optimizer tracing

DATABASE STORAGE OBJECTS

  • Storage options
  • Oracle Partitioning
  • Star schema design
  • Partitioning Examples
  • Indexes Overview
  • B-Tree Indexes & Examples
  • BitMap Indexes & Examples
  • Index Organized Tables & Examples

ADVISORIES

  • BAD SQL tracing & Analysis
  • SQL tuning Advisor
  • STS (SQL Tuning Set) with SQL tuning advisor
  • SQL Access advisor
  • Implementing SQL Plan management
  • Fragmentation and Data distribution

INSTANCE/MEMORY REAL TIME TUNING

  • Shared pool tuning – Latch/Mutex, Library cache, Cursors
  • Shared pool tuning – Parses, Result cache, Data dictionary
  • Real time Activity – Shared pool Tuning
  • Buffer cache tuning – TitBits
  • Real time Activity – Buffer cache Tuning
  • PGA tuning and Sort area – Titbits
  • Automatic memory management – Concepts
  • Real time Activity – PGA Tuning

I/O TUNING

  • Oracle I/O Architecture
  • Disk I/O concepts
  • Monitoring Oracle I/O
  • All about RAID
  • Tuning I/O – Options
  • ASM solutions

BEST ARCHITECTURAL PRACTICES

  • Important parameters
  • Storage considerations
  • Memory size planning
  • High Availability – Best practices
  • Maintenance
  • Top WAIT Events
  • Application analysis
  • Pro-active monitoring approach
  • Monitoring tools in place

For Quick Contact Please Call Us : +919676516545

Batch Timings

Course Features

  • Live Instructor Led Course
  • Real Time oriented training
  • Guidance on Resume preparation
  • Mock Interviews
  • Training on latest version
  • Guidance on certification
  • Coverage of extended topics
  • Lower price