Author: user

Oracle support updated my sr to say, yes, we could use event 10132 for this purpose but that it involves some overhead, however small, as well as the 12k disk space per statement (10g) that Jonathan Lewis had already highlighted to me. If that’s undesirable, we could also use v$sql_plan as I mentioned before. This was… Continue reading Monitoring Index Usage III – Support response

I theory, this should be a much more straightforward, less contentious question than my previous – ‘What’s a Data Warehouse DBA?’ A development DBA looks after the development (and test) databases. It truly is as simple as that, but depends on the nature of the project you’re working on and the attitude and approach of… Continue reading What’s a ‘Development DBA’?

Someone sent me this link (Note for limited bandwidth users – it’s a 15 second video), which should cheer up a few Monday mornings (or perhaps evening for some readers). It’s not something I’ll be rushing to share with the boys in the house. God help poor Polly if I did … However, it’s probably… Continue reading Animal Fun?

This looks like an interesting concept – a weekly collection of interesting items for the DBA community. It’s not unusual to see blogs like this from individual bloggers. I’m not averse to the odd one myself. What might make this a bit more interesting for me is that there’ll be more ‘heads’ working on it… Continue reading Log Buffer

What a website.

If anyone has any alternative titles, that ‘Doug’s Oracle Blog’ is looking increasingly fraudulent! My (sshhh, whisper it) real family are in Sunny Spain. As I’d decided to rent a bigger car that could take all of their luggage to Glasgow Airport, I bowed to the pressure at home and agreed to take my other… Continue reading A Trip to the Beach

If I’m honest, I’m sure most of my problems have been self-inflicted and my ‘solution’ is little more than an unsatisfactory hack but if it means I don’t have to look at any HTML for a few weeks, it will do. I eventually tracked down this problem to a difference between how Firefox and IE6… Continue reading I don’t want to see HTML for a long time

Following up on another comment from Howard, I took the initrans change off the alter table … move so that it was the most basic variation and then ran it on 8i, 9i and 10g. I’ve trimmed lots of the output this time, but I have the log files if anyone wants a copy. It… Continue reading alter table … move and table stats (part II)

So what can I do? I’ve messed around with templates, updated the back-end database and I’m going round in circles. My problem? Well <pre> tags are what I’m looking for so that the output of queries are spaced correctly, but IE doesn’t like <br> tags inside <pre> tags and ignores them. Firefox doesn’t. So maybe… Continue reading Grrrrrr!

Jeff’s back 😉