My stuff at OpenWorld

Posted by


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!

  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.

Got some thoughts? Leave a comment

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

You are commenting using your 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.