(Click Category to List Courses)
38 - IT-D Information Technology - Databases and Related Technologies
IT-D 236 - Oracle Database 12c: Performance Management and Tuning
Code | Start Date | Duration | Venue | |
---|---|---|---|---|
IT-D 236 | 16 December 2024 | 5 Days | Istanbul | Registration Form Link |
IT-D 236 | 17 February 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 236 | 14 April 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 236 | 23 June 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 236 | 04 August 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 236 | 29 September 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 236 | 24 November 2025 | 5 Days | Istanbul | Registration Form Link |
IT-D 236 | 22 December 2025 | 5 Days | Istanbul | Registration Form Link |
Course Description
In the Oracle Database 12c: Performance Management and Tuning course, participants will learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, they will be introduced to Oracle Database Cloud Service.
Course Objectives
- Using the Oracle tuning methodology
- Using Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues
- Using database advisors to proactively correct performance problems
- Identifying and tune problem SQL statements
- Monitoring instance performance by using Enterprise Manager
- Tuning instance components
- Gaining an understanding of the Oracle Database Cloud Service
Who Should Attend?
- Programmers
- Database Administrators
- Data Warehouse Administrators
Course Details/Schedule
Day 1
- Basic Tuning Diagnostics
- CPU and Wait Time Tuning Dimensions
- Performance Tuning Diagnostics
- Using Automatic Workload Repository
- Defining the Scope of Performance Issues
Day 2
- Using Metrics and Alerts
- Using Baselines
- Using AWR-Based Tools
- Real-Time Database Operation Monitoring
- Monitoring Applications
Day 3
- Identifying Problem SQL Statements
- Influencing the Optimizer
- Reducing the Cost of SQL Operations
- Using SQL Performance Analyzer
Day 4
- SQL Performance Management
- Using Database Replay
- Tuning the Shared Pool
- Tuning the Buffer Cache
Day 5
- Tuning PGA and Temporary Space
- Automatic Memory
- Performance Tuning Summary with Waits
- Oracle Database Cloud Service: Overview