I’ll give myself a quota for no more than one rant a month. However, one of my pet peeves is how Oracle licenses the database. I’l probably return to why I dislike the general model in a future rant, but this on e will be specific to partitioning. To use partitioning, you have to pay…
Are you using 9i/10G and still implement optimistic locking with your own column rather than through Oracle’s pseudo column? So am I, but I couldn’t really explain why. My main (defensive) argument would be that the system was built long before 9i. Still, it would make sense for us to change it. Let’s look at…
Reading this post about why the average Oracle IT worker doesn’t read blogs got me thinking. Does the average IT worker read blogs? I’m not sure. In what I have observed, it is something a segment does. I’d contend that the average blog reader is more advanced and more thirsty for more knowledge that the…
Both Gary and Philip postd working versions. Gary’s didn’t work for me when I had the same letter more than one time in the string. Philips did work and the need to deal with each letter as if it is unique can of course be questioned. The intent was for a solution that could handle…
While maybe a pretentious title, I’ve always enjoyed getting and giving what I call SQL Challenges. It is basically a short explanation for what you should do with pure SQL and some limitations to how you can do it and then you get to try to come up with a solution. It is frequently more…
I don’t know of a better name for this feature. I think this name describes the function well, even if it may sound overly ambitious. This whole post will be based on a post by Laurent Schneider where he uses XML features to do a select count(*) from different tables and return the result in…
Instead of having to look at your different alert logs for ORA-00600 errors frequently, why not have them come to you? This post will, as promised, show the Perl code needed to publish a feed with ORA-00600 errors. This is building on the previous two posts that shows how to create an external table for…
Time to expand on the last post. As promised this will be about how to get the ORA-00600 information out of an external table for the alert log. We will use the same user and setup as we had in that post. Lets first review how an ORA-00600 is represented in the alert log. The…
I’m going to discuss how to get SQL access to your alert log in this entry. I will then build on that to make it even more useful in future posts. Browsing the alert log can be convenient if you’re already on the server. However, it is often not possible or at least not overly…
Sign up with your email address to receive our weekly news