Oracle Database 11g: Performance Tuning

Giới Thiệu Khóa Học Oracle Database 11g: Performance Tuning

Get the most out of your 11g Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database 11g automatic tuning features, as well as practicing the manual tuning methods using the statspack tool. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops.

Đối Tượng Tham Gia

- Database Administrators
- Support Engineer
- Technical Consultant

Thời Lượng

40 hours

Nội Dung Khóa Học Oracle Database 11g: Performance Tuning

- Performance Tuning Overview
- Statistics and Wait Events
- Metrics, Alerts, and Baselines
- Using Statspack
- Using AWR
- Reactive Tuning
- Tuning the Shared Pool
- Tuning the Buffer Cache
- Automatic Shared Memory
- Checkpoint and Redo Tuning
- Tuning I/O
- Tuning PGA and Temporary Space
- Tuning Block Space Usage
- Initial Configuration
- SQL Plan Management
- Change Management

Oracle database 11g, Khóa học performance tuning, Khóa học trị dữ liệu, Quản trị cơ sở dữ liệu