Author: user

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

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

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

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

Charles Hooper has written a number of impressive blog posts in a fairly short space of time (the man is a blogging machine!) but I really wanted to draw attention to one in particular.Fault Quotes 6 – CPU Utilization Why? Well I seem to be spending more and more of my time talking about these… Continue reading Thinking about CPU