Thanks to everyone who joined me for part 1 of my Oracle SQL Performance webinar series! Embarcadero will be posting the recording within the next few days. In the meantime, I thought I'd post the slides and a few scripts that were shown.
Thanks again and I hope to see you again next month for part 2!
Presentation slides (PDF)
Scripts (ZIP)
Tuesday, July 31, 2012
Tuesday, July 17, 2012
July 31 Webinar
Please join me for another Embarcadero sponsored Community Webinar on July 31. This is the first in a series of three webinars. My topics for this triple feature are:
Diagnosing SQL Performance Problems (July 31)
Making SQL Performance Solutions "Stick"
Making Impactful Performance Changes
Here's a bit about what I'll cover in this first event:
Karen Morton begins her DBA Performance Series with Diagnosing SQL Performance Problems, designed to help DBAs understand the context in which SQL problems arise and present a framework to efficiently diagnose SQL issues, including: immediate items to identify, rule out, and confirm as well as identifying "fast" fixes to get performance back on track quickly.
You'll learn
How to distinguish between SQL and non-SQL performance optimization issues.
How to target typical cases that cause SQL to perform poorly and resolve them without rewriting SQL.
How to identify when a SQL statement needs to be rewritten to permanently solve performance inconsistencies.