Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
コース概要
Introduction
- Overview of Oracle Database Appliance
- Deployment scenarios and use cases
- Initial configuration and setup
Oracle Database Performance Tuning Basics
- Introduction to performance tuning
- Performance metrics and key indicators
- Understanding workload and system performance
SQL Tuning
- Basics of SQL tuning
- Using Oracle SQL Tuning Advisor
- SQL Plan Management
- Optimizing queries for performance
Instance Tuning
- Instance tuning overview
- Using Oracle Automatic Workload Repository (AWR)
- Understanding and using Active Session History (ASH)
- Identifying and resolving common instance-related performance issues
Advanced Performance Diagnostics
- Using Oracle Diagnostics Pack
- Using Oracle Enterprise Manager for performance monitoring
- Advanced troubleshooting techniques
Tuning Oracle Database on ODA
- Specific tuning considerations for ODA
- Resource allocation and management
- High Availability and disaster recovery tuning
- Best practices for ODA performance optimization
Summary and Next Steps
要求
- Basic knowledge of Oracle Database administration
- Familiarity with SQL and PL/SQL
- Understanding of database performance concepts
Audience
- Database administrators
- System administrators
21 時間
お客様の声 (5)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
コース - Oracle Database 19c PL and Advanced SQL
The exercises were explained very good.
Monica - DB Global Technology
コース - PL/SQL in Oracle 19c
複雑な機能とその応用方法を学びました
Ana Alexandrescu - DB Global Technology
コース - Oracle SQL Advanced
Machine Translated
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
コース - ORACLE SQL Fundamentals
It was quite hands-on, not too much theory.