Undo is conceptually the opposite of redo. Undo information is generated by the database as you make modifications to data 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
This question is often asked. The simple short answer is no, since redo logging is crucial for the database; it Read More
Here is some general information about tables, regardless of their type: •\ A table can have up to 1000 columns, Read More
A segment in Oracle is an object that consumes storage on disk. While there are many segment types, the most Read More
So, why is a COMMIT’s response time fairly flat, regardless of the transaction size? It is because before we even Read More
This, like the cannot allocate new log message, is something the DBA must fix, typically in conjunction with the system Read More
We will define each type of table before getting into the details. There are nine major types of tables in Read More
In this section, we’ll discuss block cleanouts, or the removal of “locking”-related information on the database blocks we’ve modified. This Read More