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)

4 comments:

Tony J said...

Thank you very much.

Karen said...

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

Connor McDonald said...

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

Karen said...

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