-
Dynamic in-line queries
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…
-
Creating a feed with ORA-00600 errors
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…
-
Querying the alert log for ORA-00600
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…