Search

Top 60 Oracle Blogs

Recent comments

webinar

Webinar Material

Thanks everyone who attended my last webinar at AllThingsOracle.com.

The recording of the webinar and all scripts used during the live demos are now available for download.

The README.TXT contains a description of the scripts used - there are a couple of helper scripts along with the main scripts, so that should allow you understanding which scripts you need to use for reproducing the issues demonstrated.

Furthermore the README contains links to some of the resources on the Internet that address questions that were raised during the Q+A session.

Thanks again to AllThingsOracle.com and James Murtagh for hosting the event.

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)

Free Webinar

In a couple of days, on Wednesday, 1st of August, I'll be presenting another free webinar hosted at AllThingsOracle.com.

Although it is called "Oracle Cost-Based Optimizer Advanced Session", don't be mislead by the title.

It is not a truly "advanced" session, but rather I'll try to delve into various topics that I could only mention briefly or had to omit completely during the first webinar on the Cost-Based Optimizer.

In principle it's going to be a selection of the most recurring issues that I come across during my consultancy work:

- I'm going to spend some time on statistics and histograms in particular and what I believe are the most important aspects to understand regarding them

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:

Making SQL Performance Solutions "Stick"
Making Impactful Performance Changes

All Things Oracle Webinar

Thanks to everyone who attended my webinar sponsored by Red Gate and All Things Oracle. My topic was "How to Gather SQL Resource Consumption Metrics in Oracle". The webinar recording has been posted at AllThingsOracle as of May 9 but I thought I'd also make the materials available here for anyone interested. In the zip file, you'll find a PDF of the presentation slides, several example reports (ASH, AWR, SQL Monitor) as well as several scripts I used and a text file containing all the demo queries and output.

Webinar Recording

So to wrap this up, the webinar recording (this time hosted on YouTube, the recording available from the webinar archive is hosted somewhere else) along with the webinar material for download is now officially available on AllThingsOracle.com.

I suggest that if you still have any questions regarding this webinar then you can comment on the post over there and I'll try to address them.

If you interested in more stuff like that, then stay tuned as there are more of them planned covering many of the aspects that I deliberately left out or mentioned only briefly in this basic introduction.

Webinar Material

Thanks everyone who attended yesterday's webinar at AllThingsOracle.com.

I hope the technical difficulties with my new mic (which of course work flawlessly during several test runs) weren't too severe so that you could still understand what I said.

As usual when I do presentations in English it took me far too long so probably some of you missed the end of the session. If you did you may want to check the webinar recording once available at the webinar archive at AllThingsOracle.com, because we had a very good and extensive Q+A session with excellent questions asked.

Thanks again to AllThingsOracle.com and James Murtagh for hosting the event.

Thanks for attending the webinar!

Thanks to everyone who attended my two Embarcadero sponsored webinar sessions. I promised to make the slides and some scripts demonstrated in the slides available so here they are:

Slide deck (pdf format)
Scripts (zip format)

Keep an eye out for more webinars I'll be conducting in the coming months!

April 5 Webinar (sponsored by Embarcadero)

I'll be conducting a webinar entitled Best Practices for Developing Optimally Performing SQL on April 5. Embarcadero is sponsoring the event as part of their commitment to support the Oracle community with growth and learning opportunities.

The webinar will be offered twice on April 5.
- 6:00 am PDT / 9:00 am EDT / 13:00 GMT / 2 pm in UK
or
- 11:00am PDT / 2:00pm EDT / 18:00 GMT / 7 pm in UK

I'm normally hesitant to use the label "Best Practices" as I think things often get labeled as such and people forget to test and verify them in context of their own situations and end up creating as many problems as they attempt to solve. So my list of best practices doesn't include specific do's and don'ts. My list is more about how to approach SQL development with a strong emphasis on several key areas: