Top 60 Oracle Blogs

Recent comments


UKOUG and Microsoft Marathon Webinar

I’m here for the last day of #0000ff;">UKOUG Tech17 and it’s been an awesome event.  This is my first time to this event while in Birmingham and although quite the party town on the weekends, its a great city to have an event like UKOUG’s trio of events during the week.

Where is Goth Geek Girl, Week 37

It was a really busy summer and ended with me returning after a week of vacation in Singapore.  What should I do after a 17hr flight and jet lag?  Two webinars and a SQL Saturday event!  What better way to get over jet lag and get my game back on and just jump back in!

Webinar Followup

Thanks everyone who attended my recent webinar at

The link to the webinar recording can be found here.

The presentation PDF can be downloaded here. Note that this site uses a non-default HTTP port, so if you're behind a firewall this might be blocked.

Thanks again to and Amy Burrows for hosting the event.

Free Webinar "Oracle Exadata & In-Memory Real-World Performance"

It's webinar time again.

Join me on Wednesday, January 28th at for a session based on a real world customer experience.

The session starts at 3pm UK (16:00 Central European) time. The webinar is totally free and the recording will made available afterwards.

Here's the link to the official landing page where you can register and below is the official abstract:

Free Webinar

It's webinar time again.

Join me on Wednesday, May 8th at for an overview session on the specifics of Oracle Parallel Execution.

The session starts at 16:00 UK (17:00 Central European) time. The webinar is totally free and the recording will made available afterwards.

Here's the link to the official landing page where you can register and below is the official abstract:


Webinar - Understanding Oracle Optimizer Statistics

Embarcadero is sponsoring another Oracle Community webinar on January 29  (rescheduled) February 5 conducted by yours truly. Register for Understanding Oracle Optimizer Statistics and join me as I cover

Multiple Adverts

Just a couple of announcements:

1. I had the message already a couple of days added to the "Upcoming Public Appearances" sidebar on the right hand side of this page, now the official home page is available and registration open for the "CBO Days" at Trivadis 11th and 12th December in Zurich.

Join Mohamed Zait (Manager of the Query Optimizer Group at Oracle), Maria Colgan (Senior Principal Product Manager at Oracle), Jonathan Lewis, Jože Senegačnik, Christian Antognini and myself for two days fully focused on the Cost-Based Optimizer. You will not only learn about the history and present, but also the future of this very important Oracle Database component.

2. Oracle University is going to organize my one day master class "Mastering Parallel Execution" from December on.

Making Impactful Performance Changes Webinar Follow-up

Thanks everyone who attended the 3rd segment of my 3-part DBA Performance webinar series. I enjoyed delivering them and hope you found them informative and useful.

You can find the recording here and the presentation slide deck here.

There were two SQL statements in the deck that were used to produce execution plan output (either using dbms_xplan.display_cursor or dbms_sqltune.report_sql_monitor). So you won't have to type them if you want to use them, here they are:

-- SQL to produce execution plan using dbms_xplan.display_cursor

Webinar Material

Thanks everyone who attended my last webinar at

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