Learning is not a spectator sport

September 16, 2013

My stuff at OpenWorld

Filed under: Uncategorized — connormcdonald @ 9:20 pm


Analytic Functions [UGF7455]

Analytics have been with us since Oracle8i Database Release 2 (8.1.6), but they are still dramatically underused by application developers. This session looks at the syntax and usage of analytic functions and how they can supercharge your SQL skill set.

SQL Tuning 101 [CON7457]

It’s the age-old problem: the SQL statement that needs to run in 5 seconds unfortunately runs in 10 seconds or 10 minutes, or 10 hours. A SQL statement is e-mailed to you with the simple subject line "Make it faster!". This presentation starts from this point in the process and looks at what you can do to tackle this common issue.

Optimizer Statistics: A Fresh Approach [CON7442]

The optimizer must try to be all things to all people, and similarly, the collection of optimizer statistics must try to satisfy the needs of all. And many DBAs just leave it at that. But the optimizer offers so much more than that. With a little more effort and discipline, we can achieve much more than a one-size-fits-all policy and maximize the benefits of all of the optimizer features. This session looks at the tools now available under DBMS_STATS to provide more stability and better performance with optimizer statistics.

Or the links are here


I hope to see you all there…


  1. Hi Connor. I attended the Fresh Approach session and found your presentation skills to be amazing. The session was humorous and engaging – and I learned a few things along the way :)

    Will you be posting your slides? Thanks!

    Comment by Bob Sislow — September 28, 2013 @ 9:33 am

  2. I attended “analytics”. Wish I have time to attend the other. Are you going to post your slides ? or you may send to me directly. Thanks.

    Comment by Jun He — September 29, 2013 @ 10:34 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The WordPress Classic Theme. Create a free website or blog at WordPress.com.


Get every new post delivered to your Inbox.

Join 93 other followers

%d bloggers like this: