In this chapter, we investigated how to measure redo. We also looked at the impact that NOLOGGING has on redo Read More
The previous table will have lots of blocks as we get about six or seven rows per block using that Read More
This is a frequently asked but easily answered question. The presence of indexes (or the fact that a table is Read More
I get this question all of the time. You are getting warning messages to this effect (this will be found Read More
We’ve looked at various failure scenarios and different paths, and now we’ve finally made it to the COMMIT. Here, Oracle Read More
In regard to undo generation, private temporary tables behave similar to global temporary tables. We can see that by running Read More
As a developer, you should have a good understanding of exactly what goes on during a COMMIT. In this section, Read More
You can instruct Oracle to store the undo for a temporary table in a temporary tablespace via the TEMP_UNDO_ENABLED parameter. Read More
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