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
Before compiling the Java code, we need to set our CLASSPATH variable (this should all go on one line, no Read More
There are two ways to use the NOLOGGING option. You have already seen one method— embedding the NOLOGGING keyword in Read More
As a developer, you should have a good understanding of exactly what goes on during a COMMIT. In this section, Read More
Upon startup, Oracle would read the redo log files and find some redo log entries for our transaction. Given the 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
Redo log files are crucial to the Oracle database. These are the transaction logs for the database. Oracle maintains two Read More
Surprisingly to many people, the SELECT will have generated redo. Not only that, but it will also have “dirtied” these Read More