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.
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.
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
- Expert Oracle instructors across the globe
- Get hands-on experience
- Industry-recognized Course Completion certificate provided
- Training provided across 100+ locations globally
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
- Lifetime access to recorded self-paced eLearning course created by industry experts
- 3.simulation test for Practice
- 24x7 learner assistance and support
Live Instuctor-Led Training
- Includes all in Self-Paced eLearning Model
- Live, online classroom training
- Revision classes valid for 3 months after training
- 24x7 support & assistance
Corporate Training
- 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
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.