Oracle Database 10g 11g Performance & Tuning Training Course
| Course code: |
ORACPERF |
| Details: |
|
| Onsite | Enquire about bringing this course to your offices |
| Who should attend: |
Database administrators, application developers and technical support staff who are required to monitor and tune Oracle Database 10g. |
| Prerequisite skills: |
A working knowledge of Oracle SQLPlus and Oracle 10g Database Administration. |
Course Outline
This course explores both issues and analysis of database performance, and then focusses on the tuning of Oracle SQL Language to improve performance. You will gain experience in the cost based and rule based optimisers, and Oracle utilities that are provided to allow the tuning of SQL code. A performance tuning text book is provided with the course. Available as a public or closed course at our London training centre, or can be tailored to your team's requirements and delivered onsite as a bespoke, customised training course.
Course Content
Course content has been developed for real-world, commercial scenarios by our expert. if you have a technical query email sales@jbinternational.co.uk.
What you will learn
At the end of the course the delegate should be able to:
- Use different tuning methodologies
- Use the database advisors to proactively tune a database
- Use AWR tools to tune a database
- Detect and tune common database performance problems
- Use Enterprise Manager to monitor an Oracle database
- Tune applications for optimal performance
- Optimize SQL queries for faster access
- Tune code to reduce disk I/O and network traffic
Oracle Database 10g Performance & Tuning Training Course Outline
Tuning goals and methodology
Common tuning problems
Log a SR with Oracle support
Statistics and wait events
Metrics, alerts and baselines
Statspack
Automatic Workload Repository
Tune the SGA and Shared Pool
Tune the data block buffers
Automatic Shared Memory Management
PGA and temporary space
Checkpoint and redo log tuning
Manage disk I/O
Manage undo information
Tune block space
Initial database configuration
Tuning Database Applications for Optimal Performance
Managing Statistics
Creating and Using Indexes
Creating and Using Views
Structuring SQL Statements for Performance
Using the SQL Optimizers
Examining the Execution Plan of a SQL Statement using EXPLAIN PLAN
Examining the Efficiency of SQL Statements using SQL Trace and Autotrace
Using Hints to Influence Execution Plan
Identifying Unused Indexes
PL/SQL Tuning Issues
