Category: Uncategorized

Hard at work preparing for my presentation yesterday until it got nearer to 5pm and people started coming in on their flights. First up was Kevin Closson, who looked a somewhat sad sight (by his usual standards), clutching a bag from a PC store containing what he hoped would be the crucial bit of software… Continue reading Hotsos 2010 – Day 1.79 – Friends show up

A 3:30 start, which gave me lots of time to work on my demos and by breakfast time at 7:30, I felt in a reasonable place (but not quite done yet) and headed down to eat … wait for it … some fruit! Then again, I’d eaten so little the previous day that I had… Continue reading Hotsos 2010 – Day 2 – The conference begins

Let’s see how well I can stick to this Sunday18:00 – Registration and Reception21:00 – Bed Monday09:45 – Tom Kyte: All About Metadata: Why Telling the Database about Your Schema Matters   11:00 – Richard Foote: Oracle Indexing Myths12:00 – Lunch (make sure new laptop works with projector, get changed and start panicking a bit more)13:00… Continue reading Hotsos 2010 – My Agenda

It’s 4am on Sunday, so it must be America. This time I think I’m going with the Jonathan Lewis approach of sticking to GMT while I’m over here and accepting I’ll be waking up at some ungodly hour which means I can get several hours work done before the day kicks off. That might mean… Continue reading Hotsos 2010 – Day 0 – Cuddly Toy Carnage

What a great video! I present my evidence, Your Honour … 0:50 – You get a sense of how scary it might be to speak in Hall 1.0:59 – Kurt the DUDE guy falls asleep whilst listening to a keynote.1:32 – Tony Davis, ex-Apress editor points out that it’s the networking, stupid!2:12 – Robyn Sands… Continue reading Video: UKOUG Conference Series Technology & E-Business Suite 2009

In the last post I illustrated the problems you can run into when you rely on Oracle to aggregate statistics on partitions or subpartitions to generate estimated Global Statistics at higher levels of the table. Until there are statistics for all of the relevant structures then aggregation won’t take place so, for example, if you… Continue reading Statistics on Partitioned Tables – Part 4

Actually, before looking at any recent features, let me introduce one more aspect of the existing aggregation approach used by Oracle. The examples used to date have been based on INSERTing new rows into subpartitions and, although that’s the approach used for some of our tables and will suit some systems, the likelihood is that… Continue reading Statistics on Partitioned Tables – Part 5

Registration for MOTS is now open. If you fancy a couple of days intense learning from some of the best Oracle minds, or simply some chat about Cuddly Toys over a few beers prior to going to Oracle Openworld, sign up now for a mere $450. I talked about it more here. Updated later –… Continue reading Advert: Michigan Oak Table Symposium registration open

As soon as I’d committed my last post, I knew it wasn’t what I’d hoped for and said as much to a couple of people before they’d read it. I knew it would probably just add to any confusion people already had about this subject (something I’m particularly keen to avoid) but I am awash… Continue reading Statistics on Partitioned Tables – Part 3

In the last part, I asked you to trust me that true Global Stats are a good thing so in this post I hope to show you why they are, to make sure you don’t kid yourself that you can avoid them. (Updated later – this is all on 10.2.0.4) Why would you even want… Continue reading Statistics on Partitioned Tables – Part 2