In this chapter, we investigated how to measure redo. We also looked at the impact that NOLOGGING has on redo Read More
This cause of the ORA-01555 error is hard to eliminate entirely, but it is rare anyway, as the circumstances under Read More
This is a frequently asked but easily answered question. The presence of indexes (or the fact that a table is Read More
As part of processing transactions, Oracle captures how the data is modified (redo) and writes that information to the log Read More
By changing the COMMIT to ROLLBACK, we can expect a totally different result. The time to roll back is definitely Read More
This behavior will most affect you after a large INSERT (as just demonstrated), UPDATE, or DELETE—one that affects many blocks Read More
As a developer, you should have a good understanding of exactly what goes on during a COMMIT. In this section, Read More
Redo log files are crucial to the Oracle database. These are the transaction logs for the database. Oracle maintains two Read More
Now, earlier I mentioned that we were using a Java program and not PL/SQL for a reason—and that reason is Read More
The situation is such that DBWn must make room and our modified blocks are to be flushed from the cache. Read More