Skip to content

Innovative Technology Solutions

Oracle Database 12c: Performance Management and Tuning

This course is planned for Database Administrators. After completing this course, students will be able to learn about the performance analysis and tuning tasks on Oracle 12c database. Students will also learn tuning and diagnosis of SQL-related performance. This course is best suited for Data Warehouse Administrators and Database Administrators.

8435 Ratings
4.6/5

7863 Learners

Oracle Database 12c: Performance Management and Tuning Course Overview

In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.

Oracle Performance and Tuning

Learning Objectives

  • Use the Oracle tuning methodology.
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues.
  • Use database advisors to proactively correct performance problems.
  • Identify and tune problem SQL statements.
  • Monitor instance performance by using Enterprise Manager.
  • Tune instance components.
  • Gain an understanding of the Oracle Database Cloud Service.

Key Features

Benefits

  • The DBA will analyze the SQL performance with available tools. The DBA will be introduced to various methods of identifying the SQL statements that require tuning and the diagnostic tools used to find ways to improve performance. This will include the use of statistics, profiles to influence the optimizer, and using the SQL Advisors.

Training Options

Self-Paced eLearning

19,999
  • Lifetime access to recorded self-paced eLearning course created by industry experts
  • 3.simulation test for Practice
  • 24x7 learner assistance and support

Corporate Training

Customized
  • Live Instructor Led / Campus delivery model
  • Flexible pricing options according to your requirements
  • Pre & Post evaluation test for comparison
  • 24x7 support & assistance

Course Curriculum

Upon Completion of this Course, you will accomplish following:-

  • Comprehend how to tune and diagnose common Instance related performance issues
  • Comprehend how to tune and diagnose common SQL related performance issues
  • Comprehend how to view Histograms
  • Comprehend Server-Generated Alerts
  • Comprehend benefits of Metrics
  • Comprehend how to view Metric History Information
  • Comprehend how to employ methodology of Database tuning
  • Comprehend how to employ database advisors to practically tune an Database Instance
  • Comprehend how to employ Enterprise Manager performance-related pages to scrutinize an database
  • Comprehend how to employ Automatic Workload Repository
  • Comprehend how to set Thresholds

Pre-requisites

  • Oracle Database 12c: Administration Workshop.

Course Content

  • Introduction
    Basic Tuning Diagnostics
    Using Automatic Workload Repository
    Defining the Scope of Performance Issues
    Using Metrics and Alerts
    Using Baselines
    Using AWR-Based Tools
    Real-Time Database Operation Monitoring
    Monitoring Applications
    Identifying Problem SQL Statements
    Influencing the Optimizer
    Reducing the Cost of SQL Operations
    Using SQL Performance Analyzer
    SQL Performance Management
    Using Database Replay
    Tuning the Shared Pool
    Tuning the Buffer Cache
    Tuning PGA and Temporary Space
    Automatic Memory
    Performance Tuning Summary with Waits
    Oracle Database Cloud Service: Overview

Participation Certificate

Reviews

Rohit
Rohit
2020-04-13
Verified review
Training was good , thanks for the session.
Abhishek Hegde
Abhishek Hegde
2020-04-10
Verified review
Decently conducted training on Azure related to AZ-900 course. Relatable examples taken by the instructor for basics. Needed even more in depth and maybe more concepts and time with pros and cons. Overall good one.
Madhur Mall
Madhur Mall
2020-04-10
Verified review
Session was good covering basics with simple and relate-able examples.
Chetan Gullia
Chetan Gullia
2020-04-10
Verified review
Amazing experience while having Azure Cloud Training :).
Dharmendra Kumar
Dharmendra Kumar
2020-04-10
Verified review
Bhavesh Pali is a excellent trainer. Azure cloud training was awesome and well explained by Bhavesh. Thanks Again to ITS group.
Swapnil Phirke
Swapnil Phirke
2020-04-10
Verified review
Very good Training and specially trainer Mr Bhavesh has good enough knowledge to answer all queries, content is also good. Training duration need to increase as trainer has more things to share but not possible to lack of time
Kapil Ahuja
Kapil Ahuja
2020-04-10
Verified review
All modules were well covered with examples , The conceptual understanding provided by using whiteboard also helped us to grasp the concepts faster.
Nirbhay Singh
Nirbhay Singh
2020-04-10
Verified review
Thanks Bhavesh for Azure Fundamentals - AZ900

Why Innovative Technology Solutions

Our Virtual Instructor Led Training model brings classroom learning experience online. With our world-class LMS instructor-led training, self-paced E-learning and personalized mentoring you will get an immersive first-class learning experience.

Self-Paced E-learning

A self-paced e-learning with recorded video sessions that you can access anytime without going beyond your comfort zone.

Live Virtual Classroom

An interactive classroom style virtual instructor led training to engage and learn more alongside your peers with a live trainer.

Learner's Community

A Social forum where you can ask your questions, one of our expert will reply you within 24 hours on that community.

Online Access of Labs

Online access of practise labs that you can access anytime, anywhere your machine.

Industry Based Projects

Real-time Industry based projects will be shared by the trainers throughout the program

24/7 Assistance

Get engaged with integrated support assistance on your desktop and mobile learning

FAQs

Trainer will be Oracle certified having more than 15 years of experience in training and working in the IT field.

Our Online classroom (Instructor-Led) training for Microsoft Azure Administrator will be conducted via live streaming app like zoom, Web-ex, or blue jeans by an Microsoft certified trainer having experience of more than 15 years in IT domain & training.