Pages

▼

Tuesday, July 31, 2012

Diagnosing SQL Performance Problems Webinar Followup

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)
at

4 comments:

  1. AnonymousJuly 31, 2012 at 4:18 PM

    Thank you very much.

    ReplyDelete
  2. KarenJuly 31, 2012 at 6:33 PM

    Tony - I don't like to type any more than I have to either. Hope the scripts are useful! - Karen

    ReplyDelete
  3. Connor McDonaldAugust 1, 2012 at 3:15 AM

    Hi Karen

    Thoroughly enjoyed the slides.

    Just a suggestion. Using v$sqlstats can be a less intrusive means of getting data than v$sql or v$sqlarea.

    Cheers
    Connor

    ReplyDelete
  4. KarenAugust 1, 2012 at 11:13 AM

    Thanks Connor.

    You're absolutely right about v$sqlstats being a better, faster, more scalable choice. I've been meaning to go through my pile of scripts and clean up things like that for ages...maybe now is a good time to do so!

    Karen

    ReplyDelete