Oracle Database 19c: Performance Management and Tuning
Duration : 5 Days (40 Hours)
Oracle Database 19c: Performance Management and Tuning Course Overview:
The Oracle Database 19c: Performance Management and Tuning certification validates professionals’ expertise in effectively managing and tuning Oracle databases for optimal performance. The certification covers various topics, including diagnosing common problems, utilizing statistics, managing database objects, leveraging the Automatic Database Diagnostic Monitor (ADDM), and working with the advisor infrastructure. Industries use this certification to verify individuals’ or teams’ skills and knowledge in maintaining an efficient database environment.
Obtaining this certification can lead to higher database performance, reduced downtime, and improved data management, resulting in cost savings and increased business productivity. Roles well-suited for this certification include Database Administrators, IT Managers, and Database Designers.
Database administrators seeking to optimize Oracle Database 19c performance
IT professionals longing for better management of Oracle Database systems
Database designers and developers looking to minimize application inefficiencies
Systems analysts wanting to improve their skill set with Oracle Database 19c tuning
Oracle Database 19c certification aspirants seeking hands-on training
Learning Objectives of Oracle Database 19c: Performance Management and Tuning:
- Identifying, diagnosing, and resolving performance issues in Oracle Database 19c.
- Harnessing Oracle’s database tuning facilities to optimize database performance.
- Analyzing and optimizing SQL performance for improved query execution.
- Using the Automatic Workload Repository (AWR) for effective database monitoring and performance analysis.
- Enhancing understanding of the Oracle Database architecture and its execution plans.
- Interpreting diagnostic information within the Oracle database to address performance bottlenecks.
Module 1: Overview
Module 2: Defining the Scope of Performance Issues
- Defining the Scope of Performance Issues Objectives
- Tuning Life Cycle Phases
Module 3: Using the Time Model to Diagnose Performance Issues
Module 4: Using Statistics and Wait Events to Diagnose Performance Issues
- Using Statistics and Wait Events to Diagnose Performance Issues
- Instance Activity and Wait Event Statistics
Module 5: Using Log and Trace Files to Monitor Performance
Module 6: Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
Module 7: Using Statspack to View Performance Data
Module 8: Using Automatic Workload Repository
- Using Automatic Workload Repository
- Managing AWR Data in a Multitenant Environment
Module 9: Using Metrics and Alerts
Module 10: Using Baselines
Module 11: Managing Automated Maintenance Tasks
Module 12: Using ADDM to Analyze Performance
- Using ADDM to Analyze Performance
- Compare Periods ADDM: Analysis
Module 13: Using Active Session History Data for First Fault System Analysis
Module 14: Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
Module 15: Overview of SQL Statement Processing
- Processing a DML Statement
Module 16: Maintaining Indexes
- Maintaining Indexes
- Automatic Indexing Task
Module 17: Maintaining Tables
- Maintaining Tables
- Block Space Management with Free Lists
- Shrinking Segments: Overview
- Advanced Index Compression
Module 18: Introduction to Query Optimizer
- Using Initialization Parameters to Control Optimizer Behavior
Module 19: Understanding Execution Plans
- Understanding Execution Plans
- SQL*Plus AUTOTRACE
Module 20: Viewing Execution Plans by Using SQL Trace and TKPROF
Module 21: Managing Optimizer Statistics
- Managing Optimizer Statistics
- Extended Statistics
Module 22: Using Automatic SQL Tuning
Module 23: Using the SQL Plan Management Feature
Module 24: Overview of the SQL Advisors
Module 25: Using the SQL Tuning Advisor
Module 26: Using the SQL Access Advisor
Module 27: Overview of Real Application Testing Components
Module 28: Using SQL Performance Analyzer to Determine the Impact of Changes
Module 29: Using Database Replay to Test System Performance
- Using Database Replay to Test System Performance
- Database Replay Packages
Module 30: Implementing Real-Time Database Operation Monitoring
Module 31: Using Services to Monitor Applications
- Using Services to Monitor Applications
- Creating Services
- Service Aggregation Configuration
Module 32: Overview of Memory Structures
Module 33: Managing Shared Pool Performance
- Managing Shared Pool Performance
- Avoid Hard Parses
- Sizing the Shared Pool
Module 34: Managing Buffer Cache Performance
- Managing Buffer Cache Performance
- Buffer Cache Hit Ratio
- Caching Tables
- Multiple Block Sizes
Module 35: Managing PGA and Temporary Space Performance
- Managing PGA and Temporary Space Performance
- Monitoring SQL Memory Usage
Module 36: Configuring the Large Pool
Module 37: Using Automatic Shared Memory Management
- Using Automatic Shared Memory Management
- Using the V$SYSTEM_PARAMETER View
Module 38: Introduction to In-Memory Column Store
Module 39: Configuring the In-Memory Column Store Feature
Module 40: Using In-Memory Column Store with Oracle Database Features
Oracle Database 19c: Performance Management and Tuning Course Prerequisites:
• Proficiency in Oracle Database technology
• Understanding of SQL
• Knowledge of Oracle Database architecture and deployment
• Previous experience or certification in Oracle Database 12c or 18c
• Familiarity with Oracle Database performance-related features
• Experience managing and tuning Oracle Database performance
• Foundational skills in computer networks and operating systems.
Discover the perfect fit for your learning journey
Choose Learning Modality
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!