Course details
Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool – Enterprise Manager – can be used to monitor an Oracle database using the many performance-related pages it provides via a user-friendly graphical user interface.
Includes 8 Chapters:
- Performance Tuning Methodology and Tools
- Using AWR and Defining Problems
- Metrics, Alerts, Baselines, AWR Tools, and Services
- Problem SQL Statements and Oracle Optimizer
- SQL Performance Management and Database Replay
- Shared Pool and Buffer Cache Tuning
- Tuning PGA, Temporary Space, and AMM
- Segment Space, I/O, and Performance Tuning
Course Location
About American Chamber
Oracle Related Questions
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Oracle APEX (Video-Based) UplatzAED 46Duration: Upto 5 Hours
- Become an ORACLE Developer eduCBAAED 99
AED 451Duration: Upto 181 Hours