Category: Archive

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

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

If you’ve ever worked on large databases that use partitioned and subpartitioned tables, you’ll be aware that there are significant challenges in maintaining up-to-date/appropriate statistics. We’ve encountered a few problems at work recently and I decided it would be an idea to put together a series of posts covering the basics of what can become… Continue reading Statistics on Partitioned Tables – Part 1

I submitted my slides last Friday so the Hotsos Symposium countdown has really started now – I’ll be presenting in just under 4 weeks time. I’m looking forward to it even more than I was for a couple of reasons. 1) I noticed from Kerry Osborne’s blog post that he’s now doing two presentations. I… Continue reading Advert: Symposium Countdown