In this chapter, we investigated how to measure redo. We also looked at the impact that NOLOGGING has on redo Read More
The scenario is this: you have a system where the transactions are small. As a result, you need very little 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
By changing the COMMIT to ROLLBACK, we can expect a totally different result. The time to roll back is definitely Read More
Before compiling the Java code, we need to set our CLASSPATH variable (this should all go on one line, no Read More
Upon startup, Oracle would read the redo log files and find some redo log entries for our transaction. Given the Read More
Redo log files are crucial to the Oracle database. These are the transaction logs for the database. Oracle maintains two Read More
Undo is conceptually the opposite of redo. Undo information is generated by the database as you make modifications to data Read More
The situation is such that DBWn must make room and our modified blocks are to be flushed from the cache. Read More
Here is some general information about tables, regardless of their type: •\ A table can have up to 1000 columns, Read More