Recent Posts

Oracle, XML, SQL

Dynamic in-line queries

TweetShareSharePin0 SharesI 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 one result table. It is like a auto generated number of selects that are unioned together. You can find Laurent’s post here. It’s a […]

SQL, RSS, Perl, Oracle, Alert Log

Creating a feed with ORA-00600 errors

TweetShareSharePin0 SharesInstead 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 the alert log and how to pull out all information for an ORA-00600 so each fetch retrieves one the data you’re interested in. The […]

SQL, Oracle, Alert Log

Querying the alert log for ORA-00600

TweetShareSharePin0 SharesTime 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 actual arguments does not matter, I took them from a forum post to just have an example. What we care about for what we’re […]

SQL, Oracle, DBA, Alert Log

SQL Access to the alert log

TweetShareSharePin0 SharesI’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 convenient. You may find that as the developer DBA you do not have access to the production server, or you have to log in […]

SQL, Oracle

Multitable insert

TweetShareSharePin0 SharesMutlitable 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 new statement as an extension of the existing INSERT statement. It allows you to insert into different tables and with different conditions from a […]

Oracle, Commit

Commit and snapshot too old

TweetShareSharePin0 SharesThe dreaded ORA-01455 hits again. Snapshot to old is easy to understand, but not always easy to fix. In this article I’ll show how the misbehaving process may actually be the process that receives the error. Snapshot too old is the problem we encounter if the block you need to access cannot be found. This doesn’t mean that the block has been misplaced by the database, but rather that the version of it that you need is no longer […]

Oracle, Humor

Learning SQL at an early age

TweetShareSharePin0 SharesPete Finnegan blogged about becoming a dad a few days back and Gary Myers followed up with his version of an SQL Primer for a toddler. This got me thinking of how the child subjected to this may react . As having SQL read out loud even with pictures from the result set may not really be all that enjoyable for a new born or even at four years of age, maybe the first reaction would be. After a […]

SQL, Oracle

The WITH clause

TweetShareSharePin0 SharesTo 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 results in over 4 billion hits on a Google search. One reason for why I like it is for how I learned about it’s […]

Undo, Oracle, I/O, Commit

Commit frequency and Undo

TweetShareSharePin0 SharesToo frequent commits can lead to performance problems, but can it also affect how much undo the updates generate? The fact that very frequent committing causes performance problems has been noticed by almost every Oracle developer with even just a couple of months experience with the Oracle database. However, if commit can increase I/O requests issued by the database, then this would also impact the performance of other processes. With Oracle, that can be done in many ways, but […]



TweetShareSharePin0 SharesIt’s time to start a blog and write down some ideas, findings, and general commentary about development with the Oracle database. This blog will be a place where I write about things related to Oracle development and performance that interests me. I have been a DBA for longer than I really want to admit as that leads to the conclusion that I’m a middle aged man today. When I started in this industry, I used to feel that the […]