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…
Mutlitable insert is a feature I’ve read about many times, but I’ve never taken the time to read up on it or play with the way this SQL statement works. I figure making a post about it will give me the reason I need to learn more about it. It is not so much a…
To mix the last post with something that may be easier to digest, I’ll make this one about one of my favorite keywords in SQL. It is the WITH clause. I can only think of one bad thing with it; it’s name. It’s virtually impossible to search for information on something with a name that…
Sign up with your email address to receive our weekly news