ORACLE DATABASE PERFORMANCE MANAGEMENT & TUNING TRAINING IN PUNE | ONLINE

Duration of Training  :  48 hrs

Batch type  :  Weekdays/Weekends

Mode of Training  :  Classroom/Online/Corporate Training

Why Radical Technologies

• The Oracle Database 19c: Performance Management and Tuning course teaches you about the performance analysis and tuning tasks expected of a database administrator. The instructions are reinforced with hands-on practices.

In this course, you will learn to:

• • Describe Performance Management
  • Use AWR Performance Statistics
  • Use AWR Based Tools
  • Improve SQL Statement Performance
  • Influence the Optimizer
  • Use Tuning Analyzers and Advisors
  • Monitor Operations and applications
  • Manage Memory
  • Manage Database Memory
  • Use In-Memory Column Store Feature

Overview

• Defining the Scope of Performance Issues
• Using the Time Model to Diagnose Performance Issues
• Using Statistics and Wait Events to Diagnose Performance Issues
• Using Log and Trace Files to Monitor Performance
• Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
• Using Statspack to View Performance Data
• Using Automatic Workload Repository
• Using Metrics and Alerts
• Using Baselines
• Managing Automated Maintenance Tasks
• Using ADDM to Analyze Performance
• Using Active Session History Data for First Fault System Analysis
• Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
• Overview of SQL Statement Processing
• Maintaining Indexes
• Maintaining Tables
• Introduction to Query Optimizer
• Understanding Execution Plans
• Viewing Execution Plans by Using SQL Trace and TKPROF
• Managing Optimizer Statistics
• Using Automatic SQL Tuning
• Using the SQL Plan Management Feature
• Overview of the SQL Advisors
• Using the SQL Tuning Advisor
• Using the SQL Access Advisor
• Overview of Real Application Testing Components
• Using SQL Performance Analyzer to Determine the Impact of Changes
• Using Database Replay to Test System Performance
• Implementing Real-Time Database Operation Monitoring
• Using Services to Monitor Applications
• Overview of Memory Structures
• Managing Shared Pool Performance
• Managing Buffer Cache Performance
• Managing PGA and Temporary Space Performance
• Configuring the Large Pool
• Using Automatic Shared Memory Management
• Introduction to In-Memory Column Store
• Configuring the In-Memory Column Store Feature
• Using the In-Memory Column Store Feature to Improve SQL Performance
• Using In-Memory Column Store with Oracle Database Features

Learn Oracle Database Performance Management & Tuning – Course in Pune with Training, Certification & Guaranteed Job Placement Assistance!

Online Batches Available for the Areas

Ambegaon Budruk | Aundh | Baner | Bavdhan Khurd | Bavdhan Budruk | Balewadi | Shivajinagar | Bibvewadi | Bhugaon | Bhukum | Dhankawadi | Dhanori | Dhayari | Erandwane | Fursungi | Ghorpadi | Hadapsar | Hingne Khurd | Karve Nagar | Kalas | Katraj | Khadki | Kharadi | Kondhwa | Koregaon Park | Kothrud | Lohagaon | Manjri | Markal | Mohammed Wadi | Mundhwa | Nanded | Parvati (Parvati Hill) | Panmala | Pashan | Pirangut | Shivane | Sus | Undri | Vishrantwadi | Vitthalwadi | Vadgaon Khurd | Vadgaon Budruk | Vadgaon Sheri | Wagholi | Wanwadi | Warje | Yerwada | Akurdi | Bhosari | Chakan | Charholi Budruk | Chikhli | Chimbali | Chinchwad | Dapodi | Dehu Road | Dighi | Dudulgaon | Hinjawadi | Kalewadi | Kasarwadi | Maan | Moshi | Phugewadi | Pimple Gurav | Pimple Nilakh | Pimple Saudagar | Pimpri | Ravet | Rahatani | Sangvi | Talawade | Tathawade | Thergaon | Wakad