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

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

Now let’s take a look at how redo and undo work together in various scenarios. We will discuss, for example, Read More