Book your Oracle Database 10g DBA Performance & Tuning Training Course
This three day course is being run three times between Monday 23rd July 2012 and Monday 3rd December 2012 in London,
Book this course with us today from as little as £1,345.50 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Provider | Location | Rating | Price | ||
|---|---|---|---|---|---|---|
| Monday 23 July 2012 | StayAhead | London |  | Save £149.50 | £1,345.50+VAT | |
| Monday 17 September 2012 | StayAhead | London | | Save £149.50 | £1,345.50+VAT | |
| Monday 03 December 2012 | StayAhead | London | | Save £149.50 | £1,345.50+VAT |
|
|
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Summary:
Delegates will be introduced to the main concepts of Oracle performance tuning and will gain practical experience in analyzing and tuning database performance. They will learn to identify tuning contentions and be able to take corrective action.
PreRequisites:
- SQL
- Oracle Database 10g DBA - Part I
Objectives:
By the end of the course, delegates will 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
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
- Materialized views
- Parallel DML
Description:
Delegates will be introduced to the main concepts of Oracle performance tuning and will gain practical experience in analyzing and tuning database performance. They will learn to identify tuning contentions and be able to take corrective action.
StayAhead
StayAhead training has been offering high quality IT technical training courses since 1992. They specialise in UNIX, Oracle, Linux and MySQL training and pride themselves on the long term investments they put into attending delegates.
StayAhead has gained a reputation for offering high quality courses and is ranked as one of the UK’s top 50 business organisations in 2008.