Category: Archive

That’s a shame. I was hoping that setting the event at the instance level might generate one trace file in the background_dump_dest but, like event 10046, it generates one trace file per session in user_dump_dest. I should have expected that, but I suppose my optimism blinded me. It doesn’t make event 10132 unusable though, but… Continue reading Monitoring Index Usage II – Event 10132

For Animal Porn 🙁 Actually, my stats are looking a lot better since I put the Tripod site back in place with redirection pages to oracledoug.com. A decent percentage of my visits are Google searches for ‘SQL decode’ and the like, so I’d been missing them ….

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?

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

What a website.

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

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)

It looks like something interesting’s going on over at Pythian’s website.