Optimizing Oracle Performance by Design with Jonathan Lewis
What you will learn:
This is a three-day intensive seminar on how to get the best out of the Oracle database engine. The seminar is aimed largely at DBA's, or developers/designers with a strong interest in the database engine. It is hard work and covers a lot of ground, so audience sizes are kept low and the course notes, sample scripts, and utilities are very detailed. The seminar evolves in line with the ever-changing versions of Oracle as old problems disappear and new features (and issues) appear.
This seminar is designed to help you to understand much of the infrastructure that Oracle is built on. Once you understand the infrastructure and have the tools to help you investigate what’s going on, you will be able to solve problems more quickly and be in a much better position to identify safe and cost-effective opportunities for improving your systems.
The course contains a lot of answers to current questions but, more importantly, it shows people how they can rapidly work out answers to the new questions that keep appearing.
| Schedule/Purchase | Training Formats | Price ** | Duration | Course Materials | Instruction Language |
|---|---|---|---|---|---|
| View Schedule | Instructor-Led Training | TRY 1,836 | 3 Days | English |
** excluding VAT
Note: To have a more personalized experience, we invite you to: Log In!
Prerequisites:
Required Prerequisites:
- Anyone attending this course should have at least three years of experience as a DBA
- or have similar experience through self-motivated investigation of what the database is doing as the fire SQL at it
- You will need to be aware of the basic concepts of SQL, DML, undo, and redo
Course Objectives:
- Oracle infrastructure – memory access, tasks consuming CPU, optimizer strategies, wait interface
- How to reduce the workload-refining SQL, changing coding strategies and taking advantage of features
- Be able to identify and resolve problems quickly