Author: user

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

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

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 😉

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)

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

Thanks for playing with us! You’re final rank in the World Cup 2006 APEX application is 92 out of 425. Some more info: – Played Games: 64 – Correct prediction of games: 41 – Wrong prediction of games: 23 – Correct prediction of score: 3 – Wrong prediction of score: 61 – Your points: 47