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.
Filed under: Advertisements — Jonathan Lewis @ 11:23 am GMT Jun 18,2013
If you’ve been keeping an eye on my Public Appearances page you’ll know that I am scheduled to go on line with Kyle Hailey for a second (more technical) discussion about Delphix and virtual databases on 19th June (tomorrow). If you haven’t registered, there’s still time to do so. It’s scheduled for 5:00 pm (BST), which makes it 9:00 am in San Francisco.
Update 1: Delphix have got 10 copies of Oracle Core to give away and they’ve decide to give one to every 10th registrant (until stocks run out) for the webinar.
Update 2: Over the last few days Kyle Hailey has been writing a short series comparing the commonest technologies currently available for Virtual Databases (or “Thin cloning”):
Filed under: Advertisements — Jonathan Lewis @ 12:30 pm GMT Jun 9,2013
The “Smarter Stats in 11g” webinar is on tomorrow (Monday 10th):
I’ve scheduled a third time for the repeats of the free webinar ”Smarter Statistics in 11g” on June 10th – 1:00 pm BST. The 6:00 pm is already full, but there are still places on the 9:00 pm showing. As before we’re using GoToWebinar as the supply mechanism, and we’ve limited access to 100 people (so if you do register and can’t attend, please remove yourself from the list). The recordings of the webinar will be available to registered listeners for 7 days after the event.
Links to register for the event:
1:00 pm BST (7:00 am Central, biased towards the UK and eastwards) (still about 30% available)
6:00 pm BST (12:00 Central, biased towards the US East Coast (currently fully booked))
9:00 pm BST (3:00 pm Central, biased towards the US west coast) (a few places left)
I’m still collecting preferred times for running the one-hour events, so if you have an opinion, pick a few times below.
Because of the help I’ve given them they’ve offered my readers the chance of winning one of two 5-user licences for the product – provided I devise a strategy for picking the recipients.
So, to make it easy, all you have to do is persuade me that you really need or really deserve a copy. Write up a short description in the comments of the worst problem you’ve had to face because you didn’t have a decent source control system, or the best use you think you could make of a source control system for Oracle.
I’ll get the redgate developers to read what you wrote, and they will be the final judges of the two most interesting, or possibly most horrifying, or maybe even the most entertaining, cases.
And there’s an online demo of the tool on March 14 at 16:00 GMT (17:00 CET / 11:00 EST / 10:00 CST / 08:00 PST), where you will be able to ask any questions. If you’re interesting in seeing it you’ll have to register at this “go to meeting” URL.
The closing date for entries is still 11th March, 23:59 GMT.
Filed under: Advertisements — Jonathan Lewis @ 8:24 pm GMT Feb 17,2012
I’m back home after a very pleasant few days in Denver. As always the RMOUG conference was great fun, the location delightful, and the people were friendly, and the organizers did a great job of looking after the presenters and making things happen. It’s a terrific event – just big enough to have a real buzz, but small enough (I’d guess about 700 – 800 people) that you don’t feel lost in the crowd.
Filed under: Advertisements — Jonathan Lewis @ 6:49 am GMT Jul 26,2011
I don’t often waste time searching the internet for evidence of my brilliance – but sometimes you’ve just got to do it ;) My O-1 visa (aliens of exceptional ability) was up for renewal, and the immigration authority decided to ask me for more evidence of the significance of my work.
In part, I think, this was because they had decided that Cary Millsap and Tom Kyte were colleagues of mine and therefore couldn’t be used as referees for Cost-Based Oracle. This put me into a weird “Catch-22″ situation – everyone I know that’s in a position to act as a referee is someone I know quite well, which means they’re just as much a “colleague” as Tom or Cary. So anyone I could ask to write a reference presumably wouldn’t be acceptable because I’d asked them!
In the end I asked the presidents of a number of international Oracle User Groups and editors of various magazines to make a statement for me – and they were all very helpful, for which I am grateful.
I also found a couple of dozen books and a handful of academic papers that reference my work – and that must have helped too. I also checked some salary surveys for the USA – it looks as if my fee income puts me somewhere between a top-rate gynaecologist and a top-rate surgeon (there’s got to be an analogy lurking there somewhere;).
Filed under: Advertisements — Jonathan Lewis @ 3:57 pm GMT Jun 17,2011
It’s official – I’m writing a new book for Apress.
The working title is: “A look at the internal mechanics of the important bits of Oracle for people who aren’t planning to become rocket scientists but who do want to do a little more than just push buttons in OEM”. (I’m still working on making the title a little more catchy.)
Congratulations to Mark Rittman of Ritmann Mead who emailed me last night to tell me that his application for an O1 visa (“aliens of exceptional ability”) to work in the USA had been granted.
There aren’t many of us around in the Oracle field (in a quick google search the I found just one other holder from the UK in a facebook entry for a Hyperion specialist) and Mark is certainly an appropriate addition to the select band.
Filed under: Advertisements — Jonathan Lewis @ 7:47 pm GMT May 26,2010
I’ll be doing a joint event with Kyke Hailey of Embarcadero in a few days time. It’s going to be a little unusual – a simultaneous webcast from opposite sides of the Atlantic – mixing my presentation about using a graphic method of tuning or designing efficient SQL with Kyle taking on the role of an active audience asking questions.
For more details and to register for this online event see this link
Update: the link now allows you to register to download the presentation and whitepaper, and to view a recording of the presentation. (See comment 7 below)
Filed under: Advertisements — Jonathan Lewis @ 10:41 pm GMT Oct 31,2009
Sorry, this isn’t a posting about efficient ways of getting the first 10 rows from a result set – it’s a little note about Oracle Open World. I don’t brag very often, but sometimes it’s hard to resist.
I’ve just received an email about Openworld with the following content: (more…)
I’ve been too busy to respond to comments on the blog for the last few days – apologies to all who have contributed, I might had some time to catch up on Thursday when I get home – but it’s hard to pass up the opportunity to point people in the direction of a little article that gave me a warm feeling of a job well done.
Warning – if you don’t want to read a description of how truly amazing I am, don’t follow this link.
After I had described the way that I can do on-site, real-time, training in trouble-shooting for a group of DBAs I got a few email messages from American companies asking if I could do something of that sort for them.
The two commonest questions were: did I set a minimum number of days for a contract before I would fly to America, and was I allowed to work when I got there.
In the UK or Western Europe, of course, it’s easy for me to travel somewhere for just one or two days – I’ve done day trips to France, Germany, Belgium, Denmark and several other countries before now when the client has been based close to an airport (or Eurostar train station).