My web log for things that professional software developers, performance analysts, or founders of companies might find interesting.
Confessions of an Oracle DBA Junkie - Arup Nanda
Here you will find posts that are mostly about my work as an Oracle DBA. There may occasionally be other topics posted, but by and large this blog will be about Oracle and other geeky IT topics. Perl will likely be mentioned from time to time.
Alex Gorbachev is Pythan CTO and frequent blogger.
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 where I was, despite using more or less the same test scripts each time (any new scripts tend to be sections of the main test script). I suspect my decision to only pull out the more interesting parts of the output has contributed to the difficulties too, but with around 18.5 thousand lines of output, I decided that was more or less essential.
It has got so bad that I noticed the other day that there were a couple of significant errors in the last post which are easy to miss when you're looking at detailed output and must be even less obvious if you're looking at it for the first time.
The fact no-one said much about these errors reinforces my argument with several bloggers that less people read and truly absorb the more technical stuff than they think. They just pick up the messages they need and take more on trust than you might imagine!
So what were the errors? Possibly more important, why did they appear? The mistakes are often as instructive as the successes.
This is the tail-end of the subpartition stats at the end of part 5
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 right over there.
1 - Default options - GLOBAL AND PARTITION
2 - Estimated Global Stats
3 - Stats Aggregation Problems I
4 - Stats Aggregation Problems II
5 - Minimal Stats Aggregation
Part 6a - COPY_TABLE_STATS
To be continued ....
P.S. It was a lot easier doing this than actually finishing off Part 6 and I'm insanely busy at the moment.
P.P.S. My ultimate intention is to re-write the blog posts as a more considered, easier-to-read article but who knows when that might happen?
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 people can see another perspective.
He also pointed out a recent blog post discussing similar subjects at Neil Gunther's blog although I must admit I've only had a quick glance at it because I'm up to my eyeballs in mail at the moment
The OakTable Challenge goes live whenever the OakTable Network sets up a stand at any of the public user-oriented events. Previous events which have seen an OakTable stand include: Miracle Open World, the UK Oracle User Group annual conference, and the Rocky Mountain Oracle User Group annual conference.
The OakTable Challenge is simple. Ask us (The OakTable members) any technical Oracle-related question and if we cannot provide you with either a solution or/and answer like, "yes", "no", "we need more information" or "cannot be done" within 24 hours, we'll give you a T-shirt that states that you challenged the OakTable Network - and won!
I wrote a latch contention troubleshooting article for IOUG Select journal last year (it was published earlier this year). I have uploaded this to tech.E2SN too, I recommend you to read it if you want to become systematic about latch contention troubleshooting:
I’m working on getting the commenting & feedback work at tech.E2SN site too, but for now you can comment here at this blog entry…