This Oracle Database 12c: Performance Management and Tuning course explore the various functionalities of performance analysis and tuning tasks to be performed by a DBA, also including diagnosis and tuning of the Oracle Database instance components, proactive management through built-in performance analysis features and tools, and tuning of SQL-related performance issues. This course will also introduce participants to Oracle Database Cloud Service.
Completion of this training course will enable candidates in:
The Database Administrator will be exposed to various methods to identify the SQL statements that require tuning and the diagnostic tools deployed in improving performance. All this will include the deployment of statistics, profiles to influence the optimizer, and deploying the SQL Advisors.
2. Basic Tuning Diagnostics
3. Using Automatic Workload Repository
4. Defining the Scope of Performance Issues
5. Metrics and Alerts Usage
6. Using Baselines
7. Using AWR-Based Tools
8. Real-Time Database Operation Monitoring
9. Monitoring Applications
10. Identifying Problem SQL Statements
11. Influencing the Optimizer
12. Reducing the Cost of SQL Operations
13. Using SQL Performance Analyzer
14. SQL Performance Management
15. Using Database Replay
16. Tuning the Shared Pool
17. Tuning the Buffer Cache
18. Tuning PGA and Temporary Space
19. Automatic Memory
20. Performance Tuning Summary with Waits
21. Oracle Database Cloud Service: Overview
This Oracle Database 12c Performance Tuning Training Course is ideal for those working with the profiles of:
Oracle Database 12c: Administration Workshop Ed 2
Suggested Prerequisites:Oracle Database 12c: Install and Upgrade Workshop
I want to express the extent of my admiration and appreciation for the organization and the effort you had made for the sake to success the training I did particularly and the success to the Institute generally. What I have seen during the past few days will be an opportunity to return again and recommend the Institute among colleagues. Interacting with many tools and share information with the students. Moreover, to that the instructor provides activities and demonstrates the process for running tools in live mode.
I like Mercury Solutions, they provided me with what they promised. All communication with the staff was good. All the tactics used to impart training was good. The trainer was an awesome person. He has a vast knowledge and knows how to train a student, he taught me with all the possibilities in the security field. He knows his subject very well. I highly recommend the trainer for all the security related trainings. The company guest house and the staff was very good. The overall transportation was also good and the drivers are helpful. They also sent me for city tours which were awesome.
I am really delighted about the SQL Training course: Querying Microsoft SQL Server with Mercury Solutions. Every session was great and very valuable. Practical application made the course significantly more valuable. The thing most impressive was the way the entire programme was structured. Instructor is having great experience and diverse knowledge in SQL Server. I am looking for learning Administering Microsoft SQL Server 2014 Databases with same trainer.
I came to make resolution to learn Cisco Security, so I chose Mercury Solutions. I learnt a lot and gained a lot. Presently, I became CCNA certified and EC-Council Penetration Tester. I learnt a lot from good lectures and from trainers, and also I enjoyed a lot and I would advise all to come down and learn."
Mercury Solutions Ltd. is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.