Category: Uncategorized

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.

Jeff’s back 😉

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!

Howard Rogers left a comment on my last blog, showing an example of using alter table … move on a 10gR2 database on Linux. In his example, unlike mine, the table rebuild did not nullify the table’s statistics. I admit I was surprised myself when I ran my example yesterday so I was concerned that… Continue reading alter table … move and table stats

Six years ago I started playing around with XML, XSL and WML/WAP using an early version of the Oracle XML Developer’s Toolkit as an interesting little change from DBA work. I ended up presenting ‘Developing Dynamic WAP-Enabled Websites using Oracle’s XML Tools’ at Openworld in San Francisco, EOUG in Madrid and UKOUG in Birmingham. You… Continue reading Technology Pioneer!

While working on the ITL deadlock problem (which looks like it’s been fixed by the initrans increase and table rebuild), the developers highlighted another table as hitting this problem in the past. When I investigated, I found that initrans had already been set to 6 so this had obviously happened in the past on the… Continue reading Table reorgs and statistics

I think that one of the most important skills of a good DBA and one of the most difficult to maintain as your experience grows is to stay open-minded. When I got into work this morning, there was an email waiting for me from a frustrated developer who wanted to know why one of the… Continue reading Being Open-minded