In this chapter, we investigated how to measure redo. We also looked at the impact that NOLOGGING has on redo Read More
If you have a fixed-size undo tablespace, then the UNDO_RETENTION parameter is ignored by Oracle. In this configuration, you can Read More
I get this question all of the time. You are getting warning messages to this effect (this will be found Read More
As part of processing transactions, Oracle captures how the data is modified (redo) and writes that information to the log 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