Oracle Database Administration - Oracle Database Certification
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
5 Days
-
Start date
Different dates available
Course Manual Certificates Experienced instructors Refreshments
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- IT
- Database
- SQL
- Database Administration
- Database training
- Performance
Course programme
Introduction
This course looks at the steps needed for a database to perform and identify problems, diagnose issues and fixing them too.
Pre-Requisites
- Delegates are required to have had some experience or knowledge of Oracle database 11g administration.
Who should attend?
This course is for:
- Support Engineers
- Database Administrators
- Technical Consultants
What will you learn?
- The ability to describe Oracle tuning methodology
- The ability to use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues
- The ability to use database advisors to correct performance problems proactively
- The ability to identify problem SQL statements & tune SQL performance problems
- The ability to monitor the Instance Performance using Enterprise Manager
- The ability to tune instance components, primarily using Instance parameters
Course Outline
- Introduction to the Basic Tuning Tools
- Implementing Automatic Workload Repository
- Identifying Problems
- Implementing Metrics and Alerts
- Implementing Baselines
- Implementing AWR Based Tools
- Overview of Monitoring an Application
- Overview of Problem SQL Statements
- Understanding ways of Influencing the Optimizer
- Implementing SQL Performance Analyser
- SQL Performance Management overview
- Implementing Database Replay
- Overview of Tuning the Shared Pool and the Buffer Cache
- Overview of Tuning PGA and Temporary Space
- Introduction to Automatic Memory Management
- Understanding Tuning Segment Space Usage and I/O
- Overview of Performance Tuning Summary
Additional information
- Gain an understanding of the Oracle Database 11g Performance Tuning
- Learn the key tools and tuning methods of identify problems
- Develop knowledge of implementing problem solutions
- GUARANTEED LOWEST PRICE IN THE INDUSTRY
- Courses delivered by world class training instructors
- Training provided in luxury venues
- Includes material and manuals
- Book Online or Call 01344 203999 to speak to a training advisor today
Oracle Database Administration - Oracle Database Certification