Surprisingly to many people, the SELECT will have generated redo. Not only that, but it will also have “dirtied” these Read More

Undo is conceptually the opposite of redo. Undo information is generated by the database as you make modifications to data Read More

This question is often asked. The simple short answer is no, since redo logging is crucial for the database; it Read More

Here is some general information about tables, regardless of their type: •\ A table can have up to 1000 columns, Read More

We will define each type of table before getting into the details. There are nine major types of tables in Read More

Now let’s take a look at how redo and undo work together in various scenarios. We will discuss, for example, Read More