Find it. Fix it. Real-World SQL Tuning Cases

By: Tim DelChiaro

Abstract: In this on-demand webinar, several real-world examples are reviewed to help you learn how to evaluate poorly performing SQL

On-Demand Webinar:
Find it. Fix it. Real-World SQL Tuning Cases

There are many ways to find SQL that is performing poorly. The hard part is what to do with a bad SQL statement once you have it. In this on-demand webinar, several real-world examples are reviewed to help you learn how to evaluate poorly performing SQL. Each example demonstrates a commonly occurring SQL performance problem and provide a method to solve it.

Key points:

  1. Why data logs are important
  2. Proper log recovery actions
  3. Log management best practices

About the presenters:

Karen Morton

Karen Morton is a consultant and educator specializing in Oracle performance optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is an Infrastructure Principal Director for Accenture Enkitec Group, a global systems integrator specializing on the Oracle platform.

For almost 30 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a DBA, a data architect and now is an author, researcher, educator and consultant. Having used Oracle since the early 90's, she began teaching others how to use Oracle almost 20 years ago.

Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network. She blogs at karenmorton.blogspot.com.

Scott Walz

Scott Walz has more than 20 years of experience in the area of database development and currently serves as the Director of Software Consultants for Embarcadero Technologies.  Prior to joining Embarcadero 12 years ago, Scott served as a development lead for Louisville Gas & Electric. He holds a bachelor's degree in computer information systems from Western Kentucky University.

Server Response from: ETNASC03