Author: user

I’m pretty self-concious of the amount of waffle that surrounds any technical content here, so let’s get the technical bit out of the way first, then the waffling can come later … I finally tracked down the mistake I didn’t make in part 6a, but thought I’d identified and fixed in part 6b! Here are… Continue reading Statistics on Partitioned Tables – Part 6d – COPY_TABLE_STATS – A Light-bulb Moment

If I didn’t laugh, I’d cry. Mid-way through a series of posts, the next one of which I plan to talk about some of the myriad bugs and related patches for DBMS_STATS in 10.2.0.4, I discovered via several blogs that the 10.2.0.5 patchset for Linux x86-64 has been released 😉

Sigh … these posts have become a bit of a mess. There are so many different bits and pieces I want to illustrate and I’ve been trying to squeeze them in around normal work. Worse still, because I keep leaving them then coming back to them and re-running tests it’s easy to lose track of… Continue reading Statistics on Partitioned Tables – Part 6b – COPY_TABLE_STATS – Mistakes

[Phew. At last. The first draft of this was dated more than two weeks ago …. One of the problems with blogging about copying stats was the balance between explaining it and pointing out some of the problems I’ve encountered. So I’ve broken up this post, with a little explanation first …] Oracle have a… Continue reading Statistics on Partitioned Tables – Part 6a – COPY_TABLE_STATS – Intro

Thanks to Marco mentioning it on Twitter, I downloaded and installed 11gR2 for Windows from OTN this evening. The reason I had to switch to OEL on VMWare was because of the delay on the 11gR2 Windows release, but I’ll give it a try and see which works best for me. Installation was certainly a… Continue reading 11gR2 for Windows 64 on OTN

Some people might have noticed that the blog has been down a few times over the past week, particularly on Friday. The server that the site and blog is hosted on has been subject to some sort of hack attack and as a result it was moved to a new server and all privileges were… Continue reading Outages

When Jonathan Lewis decided it was time to post a list of the Partition Stats posts on his blog and Noons suggested I made them easier to track down, I listened. So this post will link to the others and, at least in the short term, I’ve also included links in the side-bar on the… Continue reading Statistics on Partitioned Tables – Contents

In one of my Hotsos Symposium 2010 posts I mentioned that Peter Stalder had plugged some test results from an earlier blog post into Neil Gunther’s Universal Scalability Law to see how well the model applied. Peter’s posted his slides now and I’ve added the URL to the comments thread of the original post so… Continue reading Time Matters: Throughput vs. Response Time – Part 2

I generally wouldn’t visit the Hotsos Training Day, mainly because I’ve been away from home and work for long enough, particularly when you add the travelling time at either end, but this time I was determined to attend because Tanel was presenting. It was a busy room with a very high percentage of attendees staying… Continue reading Hotsos 2010 – Day 5 – Training Day with Tanel Poder

[One thing that’s great about jet-lag is that it allows you to catch up on blogging and all the email that’s built up while you’ve been away at the conference. Not much else you can do at 2:30 in the morning.] I’m glad I went to the Hotsos Symposium again this year. Attending conferences is… Continue reading Hotsos 2010 – Summary