Filed under: Advertisements — Jonathan Lewis @ 2:40 pm GMT Jan 27,2014
I’m going to be in Denver next week for the RMOUG Training Days – so I’ve just received an email asking me if I could stay on a couple of days and visit someone fairly close by while I’m in the area. It’s not the first time that I’ve had a last minute request like this; unfortunately I tend to book my flights weeks, and sometimes months, in advance – usually at a good price but with a hefty cancellation penalty (like, no refund), so not possible this time.
However, I’m going to be speaking at ODTUG Kscope 14 (my name’s not visible on the agenda yet) and I’m just about to book the flights but, in view of the email, I thought I’d wait a few days and let people know where I’m heading in case someone wants me to spend a couple of days on-site in Seattle at the end of the week commencing 21st June. Email me if you’re interested: firstname.lastname@example.org
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 @ 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.
Filed under: Advertisements — Jonathan Lewis @ 8:19 pm GMT Dec 20,2012
The evaluations for UKOUG 2012 are in – though perhaps not all of them have been loaded into the “Speaker Lounge” yet. I’m fairly pleased with my scores. On a range of 1 – 6:
Presentation skills: 5.8, 5.79, and 5.72
Of course I have to say that great presentation skills don’t necessarily mean that the presentation was good. I’ve seen a couple of presentations in the past where the presenter was brilliant at communicating his topic – unfortunately at least half of what he said was wrong. Conversely I’ve sat through a few presentations where the material was brilliant, but the presenter just needed lots more practice.
Fortunately I think the following scores show that it wasn’t all show and no substance:
Content Evaluation: 5.56, 5.36, 5.28
My favourite comment: on my B-trees masterclass that lasted 1 hour 50 minutes: “It should have lasted 2 hr 30″. I gave the audience a break at half time – it’s very gratifying when you do that and most of the audience come back when there are competing presentations that they could go to.
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).