The focus for the day will be on truly understanding on how the database should be, or rather is designed to be, used. Proper use can result in orders of magnitude of performance gains, think 10X, 100X and sometimes 1000X faster. The format of the training day will be a mix of presentations, interactive discussions and demos that show the performance gains. This training is targeted for an intermediate/advanced audience that likes to be challenged and is interested in getting the best possible performance out of their system.

Who we are
———–
The Real-World Performance Team is part of the Oracle Database Development organization and focuses on achieving the maximum performance from the Oracle Database and hardware in the real world.
We do this by identifying inefficiencies in current systems and applying modern database design and tuning techniques.

Over the years we have developed the Real-World Performance methodology, which uses diagnostics to articulate the problem using numbers, aiming for a solution that achieves exceptional performance using the best available tools.

Our Methods
———–
Whenever we look at a performance problem, we follow a few simple principles:
1. Use the database as it was designed to be used
2. Employ numerical and logical debugging techniques using the appropriate database diagnostics tools for the problem
3. The entire system is within scope, from applications to algorithms to database
4. Avoid and eliminate “tuning” by hacking/guessing/luck to understand root cause of the problem before implementing the solution

THIS EVENT IS CLOSED. We have reached the maximum capacity of the meeting room. We can no longer accept new participants. Should you have any questions, please contact Peggy at peggy.king@rmoug.org.

To register for the meeting go to http://www.prairiesystemsgroup.com/pls/psg/heidi_events_upd.process_event_registration?id=BC4892285D458130

Agenda
————
8:00am – 9:00am – Registration Check-in / Continental Breakfast

9:00am – 12:30pm – Morning Session
Core Oracle Database Performance Fundamentals
– Database Computer Science Basics
– Application Algorithms
– Connection Pools
– Database / Middleware Interaction

12:30pm – 1:30pm – Lunch Break

1:30pm – 5:00pm – Afternoon Session
The Optimizer
– SQL and the Optimizer
– Optimization Strategies
– Why is my SQL slow?

THIS EVENT IS CLOSED. We have reached the maximum capacity of the meeting room. We can no longer accept new participants. Should you have any questions, please contact Peggy at peggy.king@rmoug.org.

To register for the meeting go to http://www.prairiesystemsgroup.com/pls/psg/heidi_events_upd.process_event_registration?id=BC4892285D458130