• Marathahalli, Bengaluru
  • 080-41750541 - 7795029900
  • apsysieeeprojects@gmail.com
  • Mon - Sat: 9:30am - 7:00pm

Oracle Performance Tuning Course

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.

Apsys Solutions is the leading technology training institute in Bengalore providing professional trainings which are designed by keeping in mind brightest career interests of fresh graduates who will be the tomorrows innovators and leaders of the IT Industry. Our primary focus is to provide the highly industry relevant, value-added, and quality training on the latest emerging technologies.

Course Highlights

  • Expert trainers with decades of Industry Experiance
  • Focus on handson practicals
  • Convinient Batch Timings
  • VMware dump for practice purpose
  • In-depth details about Exadata machine
  • Discussion on latest version boxes
  • Monitoring tools for Exadata
  • Patching Exadata machine

Course Takeaways

  • Handson Practical Knowledge
  • Certificate from Institute
  • Recommendation and Guidance for Books
  • 3 Months Guidance & Assistance for Placement
  • Free Subscription to Technology Email Alerts
  • Guidance for Resume Preparation
  • Guidance for Interview Prepation
  • Course Material

Course Structure & Syllabus

  • 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

Leave Your Review

Related Courses