Archives for May, 2007

I'll give myself a quota for no more than one rant a month. However, one of my pet peeves is

Posted in DBA, Licensing, Oracle, Partitioning

Are you using 9i/10G and still implement optimistic locking with your own column rather than through Oracle's pseudo column? So

Posted in Uncategorized

Reading this post about why the average Oracle IT worker doesn't read blogs got me thinking. Does the average IT

Posted in Blogging, Oracle

Both Gary and Philip postd working versions. Gary's didn't work for me when I had the same letter more than

Posted in Challenge, Oracle, SQL, XML

While maybe a pretentious title, I've always enjoyed getting and giving what I call SQL Challenges. It is basically a

Posted in Challenge

I don't know of a better name for this feature. I think this name descibes the function well, even if

Posted in Oracle, SQL, XML

Instead of having to look at your different alert logs for ORA-00600 errors frequently, why not have them come to

Posted in Alert Log, Oracle, Perl, RSS, SQL

Time to expand on the last post. As promised this will be about how to get the ORA-00600 information out

Posted in Alert Log, Oracle, SQL

I'm going to discuss how to get SQL access to your alert log in this entry. I will then build

Posted in Alert Log, DBA, Oracle, SQL