Oracle Scratchpad

July 31, 2013

Cinderella

Filed under: Advertisements,Oracle — Jonathan Lewis @ 10:42 pm BST Jul 31,2013

Just a little whimsy – the most famous (misquoted?) line from the fairy-tale in the title is (probably) “you shall go to the ball”.

Despite having all my abstracts rejected I will be speaking at OOW 2013, courtesy of “the Optimizer Lady”, Maria Colgan.

Oracle Optimizer Boot Camp: 10 Optimizer Tips You Can’t Do Without [CON8643]

Jonathan Lewis – Sole Proprietor, JL Computer Consultancy
Maria Colgan – Master Product Manager, Oracle

It has long been felt that the internals of the Oracle optimizer are shrouded in mystery and that a degree in wizardry is required to be able to make it do the right thing. This session aims to dispel this myth once and for all by showing the process of analyzing and solving 10 of the most common SQL execution performance problems. These problems include poor cardinality estimations, bind peeking issues, selecting the wrong access method, and many more. Through clear how-to examples, you will learn how to identify and quickly resolve these issues and add 10 new tricks to your SQL tuning arsenal.

12 Comments »

  1. I hope you will be speaking at OakTableWorld, too! :)

    Comment by Martin Klier — August 1, 2013 @ 3:07 pm BST Aug 1,2013 | Reply

  2. This is very good news, not least for those lucky enough to attend OOW this year.

    Spare a thought for us ugly sisters :)

    Comment by Richard Foote — August 2, 2013 @ 2:23 am BST Aug 2,2013 | Reply

    • I think the analogy could be pushed a bit too far, there.
      But weren’t the ugly sisters the ones that got to the ball but didn’t have any fun ?
      And who would play the role of the handsome prince ?

      Comment by Jonathan Lewis — August 3, 2013 @ 11:08 am BST Aug 3,2013 | Reply

  3. May I wager a guess ? Your talk will NOT be able to “dispel this myth once and for all”. Myths perpetuate because not everyone pays attention to the experts (or some listen to “pretend experts”).

    Comment by Hemant K Chitale — August 2, 2013 @ 6:30 am BST Aug 2,2013 | Reply

    • That’s not a wager I’d take on.

      It doesn’t matter what Maria and I claim, there will be enough people saying: “Sure, and Hermione and Harry say there’s no such thing as magic”.

      Comment by Jonathan Lewis — August 3, 2013 @ 11:15 am BST Aug 3,2013 | Reply

  4. If anyone has a commonly appearing optimizer problem that they’d like to see a “top tip” for – feel free to tell me about it in a comment, and it may get into the presentation. (Or it might just get a quick answer as a reply.)

    Comment by Jonathan Lewis — August 3, 2013 @ 11:19 am BST Aug 3,2013 | Reply

  5. Good news – any chance the schedule organisers can put this session earlier in the week? No need to save the best until last :)

    Comment by Mark Burgess — August 7, 2013 @ 12:50 am BST Aug 7,2013 | Reply

    • Mark,

      How did you find out when the session was on ? I haven’t found the timetable yet – and I don’t have any say in it.

      From a marketing point of view, of course, it’s ALWAYS best to save the best until last – it keeps the punters on the premises.

      Comment by Jonathan Lewis — August 7, 2013 @ 9:21 am BST Aug 7,2013 | Reply

  6. For reference, and to fill in your Schedule, here are the session details:

    Session ID: CON8643
    Session Title: Oracle Optimizer Boot Camp: 10 Optimizer Tips You Can’t Do Without
    Venue / Room: Moscone South – 102
    Date and Time: 9/24/13, 17:15 – 18:15

    Comment by Jonathan Lewis — August 24, 2013 @ 4:24 pm BST Aug 24,2013 | Reply

    • Update – we’ve been moved from room 102 (pop. 500) to room 104 (pop. 1,000).
      Only 500 pre-registered, so need a few (hundred) more so the room doesn’t look empty.

      Comment by Jonathan Lewis — September 10, 2013 @ 4:46 pm BST Sep 10,2013 | Reply

  7. I’ve not mentioned my Oak Table World presentations in San Francisco yet:

    The agenda is online here, and as you will see I’ll be on at 15:00 on Monday to talk about the Approximate NDV and how it should affect your statistics collection strategy in 11g; and then at 10:00 on Tuesday to talk about histograms and how 12c has improved them and how your stats collection strategy should change when you upgrade.

    Comment by Jonathan Lewis — August 27, 2013 @ 5:31 pm BST Aug 27,2013 | Reply


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 Rubric Theme Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 3,453 other followers