COUG March 17th Presentation


Topic: Method R – Performance Optimization the Smart Way

Presenter: Chad McMahon, Senior Consultant, CGI Database Services

  • Chad McMahon has been an Oracle DBA for 8 years, and is currently a senior database consultant at CGI focusing on Oracle performance optimization for multiple clients
  • He has solved a multitude of Oracle performance optimization initiatives, ranging from assisting developers with simple query tuning, to resolving large scale mission critical ERP performance problems


So you’re late for work… How do you prevent it from happening again? Do you remove your vehicle’s surface imperfections to make the vehicle more aerodynamic? Do you ensure optimal wheel alignment to allow for faster wheel rotation? Do you ensure your engine is producing 99.9% of its rated horsepower? Or do you simply replace your Ford Taurus with a Ferrari Enzo? Chances are you wouldn’t do any of the above, but rather investigate which portion of the trip took the longest, and attempt to reduce the amount of time spent in that portion during future trips. Unfortunately this time-based performance tuning method we perform in our day-to-day lives isn’t always the same method we use when tuning processes in the Oracle database. DBAs will often attempt to solve performance problems by blindly trying to eliminate all full table scans, rebuilding indexes, ensuring a 99% buffer cache hit ratio, replacing slower hardware with faster hardware, etc. But how do you know if these actions will truly solve your performance problems without proper analysis of a process’s elapsed time breakdown.

  • This presentation will remove the so-called “black magic” behind Oracle performance tuning, revealing a proven methodology that can be used to solve virtually any performance problem
  • The Method R performance tuning methodology focuses on discovering, diagnosing, and reducing the top elapsed time consumers of any poorly performing business process within the Oracle database


Where: Suncor Energy Centre (West Tower), 150 6th Avenue SW, 17th floor Room A/B

When: Thursday March 17th, 2011.

Registration 8:00 AM, Presentation 8:30 AM, Duration: 1 hour


Check out the COUG HomePage for further information
and COUG Special Events



First4 Amec CGI Devy Oracle O'Reilly SAIT Suncor

Oracle Corporation
Oracle Enterprise Cloud Summit
Develop Your Strategy and Roadmap for Cloud Computing

The cost and speed advantages of cloud computing are clear and compelling. But how do you actually move to cloud computing? To discover a practical approach to building your cloud foundation, join us for the Oracle Enterprise Cloud Summit.

During this full-day event, cloud experts will share real-world best practices, reference architectures, detailed customer case studies, and more. You’ll learn how to transform IT into a superior service provider with a strategy and roadmap for building, deploying, and managing an enterprise cloud.

Attend the Oracle Enterprise Cloud Summit to learn how to:

  • Build a state-of-the-art cloud architecture
  • Leverage your existing IT investments
  • Optimize your IT management processes

Whether you are considering a move to cloud computing or have already adopted a cloud model, this event offers you the insights you need to take full advantage of cloud computing.

Register online now for this exclusive event. Or call 1.800.820.5592 ext. 8868.

If you are an employee or official of a government organization, please click here for important ethics information regarding this event.

Oracle Cloud Computing Break Through

Register Now
Join us for this enterprise cloud summit.
Tuesday, March 22, 2011
7:30 a.m. – 12:15 p.m.

Hotel Arts
119 – 12th Avenue SW
Calgary, AB T2R 0G8

7:30 a.m. Breakfast & Registration
8:20 a.m. Welcome & Introductions
8:30 a.m. Keynote Address: Roadmap to Enterprise Cloud Computing
9:30 a.m. Break
9:45 a.m. Breakout Sessions, Track #1 (customers choose to attend one session)

10:45 a.m. Breakout Sessions, Track #2 (customers choose to attend one session)

11:45 a.m. Networking Lunch
12:15 p.m. Closing Keynote: Planning a Cloud Implementation

Read More

Leave a Reply

May 18th Presentation Featuring Ray Smith from CGI

Presentation: RMAN “RMAN is ok for the simple recoveries but when things get complicated it’s just not good enough.” Anyone who’s been a DBA for any length of time has heard that statement but is it fair? This presentation is intended to assess RMAN’s ability to recover in various recovery scenarios and discuss the alternative in […]

Read More
View the Blog »

March 16th Presentation Featuring Martin D’Souza from Innovation at Insum

Presentation: APEX 5.1 New Features APEX 5.1 is the latest major release of Oracle Application Express. It has a lot of ...

February 16th Presentation featuring Steve Recsky from First4 Database Partners Inc.

Presentation:Oracle - Free Extended Support was to on May 31, 2017. It is now the end of December 2018 ...