Oracle Database 19c- Performance Management and Tuning

1. Overview
2. Defining the Scope of Performance Issues
3. Using the Time Model to Diagnose Performance Issues
4. Using Statistics and Wait for Events to Diagnose Performance Issues
5. Using Log & Trace Files to Monitor Performance
6. Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
7. Using Statspack to View Performance Data
8. Using Automatic Workload Repository
9. Using Metrics and Alerts
10. Using Baselines
11. Managing Automated Maintenance Tasks
12. Using ADDM to Analyze Performance
13. Using Active Session History Data for First Fault System Analysis
14. Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
15. Overview of SQL Statement Processing
16. Maintaining Indexes
17. Maintaining Tables
18. Introduction to Query Optimizer
19. Understanding Execution Plans
20. Viewing Execution Plans by Using SQL Trace and TKPROF
21. Managing Optimizer Statistics
22. Using Automatic SQL Tuning
23. Using the SQL Plan Management Feature
24. Overview of the SQL Advisors
25. Using the SQL Tuning Advisor
26. Using the SQL Access Advisor
27. Overview of Real Application Testing Components
28. Using SQL Performance Analyzer to Determine the Impact of Changes
29. Using Database Replay to Test System Performance
30. Implementing Real-Time Database Operation Monitoring
31. Using Services to Monitor Applications
32. Overview of Memory Structures
33. Managing Shared Pool Performance
34. Managing Buffer Cache Performance
35. Managing PGA and Temporary Space Performance
36. Configuring the Large Pool
37. Using Automatic Shared Memory Management
38. Introduction to In-Memory Column Store
39. Configuring the In-Memory Column Store Feature
40. Using the In-Memory Column Store Feature to Improve SQL Performance
41. Using In-Memory Column Store with Oracle Database Features

Radiant Techlearning is headquartered in the Electronic city & technology hub of Northern India, Noida, which is surrounded by several large multinational, medium & small Software companies.

We have offices located all across the country and partners across the globe.

Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant’s hand-on-practice.

Participants can easily access these labs over Cloud with the help of a remote desktop connection.

Radiant virtual labs provide you the flexibility to learn from anywhere in the world and in any time zone.

The learners will be enthralled as we engage them the real-world and industry Oriented projects during the training program. These projects will improve your skills and knowledge, and you will gain a better experience. These real-time projects will help you a lot in your future tasks and assignments.

To know about the fee details, you can email us at training@radianttechlearning.com with your requirement in detail, containing the below information.

In the case of Self/ Individual

• Training Program
• Training Mode (Online/ Classroom)
• Location (in case of the classroom)-
• Background (Education/ Technology/ Year of experience, etc. )
• Training Timeline

In the case of Corporate Training

• Training Program of Participants
•  Training Mode (Online/ Classroom)
• Location (in case of the classroom)-
• Participant’s Background (Education/ Technology/ Year of experience, etc.)
• Training Timeline
• Expectations from the training program

No. These training programs are helping to improve your skills & knowledge of the technology which would help you to land your dream job by learning them.

Our training program will maximize your ability and chances of getting a successful job. You have to select a job according to your convenience. Your performance in the training program and interview is crucial for getting a good job.

Yes, your employer can pay your fees.

The learners will be enthralled as we engage them the real-world and industry Oriented projects during the training program. These projects will improve your skills and knowledge, and you will gain a better experience. These real-time projects will help you a lot in your future tasks and assignments.