Commit or rollback a SELECT, really? Occasionally, you would be working with your favorite Oracle tool and when you are ready to close the tool, it will prompt you to either commit or rollback your work. “What work?”, you wonder. The problem is, you have only done SELECT’s. Why is it prompting you to commit … Continue reading Oracle – Why Is Toad Asking Me To Commit/Rollback A SELECT With No Transaction?
In an earlier post, we saw how Oracle’s UNDO works in very basic terms. REDO is another critical aspect that goes hand in hand with UNDO. Let us get the basics of REDO sorted out here. UNDO and REDO In its most basic sense UNDO is information saved to get back in case a ROLLBACK … Continue reading Oracle REDO – A Basic Explanation
Why is the APPEND hint so great? In a prior post, we extolled the virtues of the APPEND hint (AKA Direct Path Insert). It is a great option to use • UNDO usage is negligible. It is only generated for index maintenance and meta data changes. The keyword is index maintenance – indexes generate UNDO. … Continue reading Oracle – Is my APPEND Hint Being Ignored? How To Find Out?
If you are primarily a SQL Server developer and you are moving to Oracle, this is one of the nastiest surprises in store for you. You are so used to rolling back everything including DDL in SQL Server transactions but in Oracle, DDL inside transactions act as COMMIT. Fear not though, there are a ton … Continue reading Oracle Gotcha For The SQL Server Developer – DDL’s COMMIT Transactions Implicitly!
You might have heard the terms UNDO and REDO thrown around in conversations around space usage. In this tip, let us get a basic idea of what UNDO (formerly called ROLLBACK) is in Oracle. I promise you that this will be an interesting read and you will be happy you read this. Unlike SQL Server … Continue reading Oracle UNDO – A Basic Explanation