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…
The 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…
Pete 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…
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…
Too 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…
It’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…
Sign up with your email address to receive our weekly news