In this chapter, we investigated how to measure redo. We also looked at the impact that NOLOGGING has on redo Read More
The previous table will have lots of blocks as we get about six or seven rows per block using that Read More
This cause of the ORA-01555 error is hard to eliminate entirely, but it is rare anyway, as the circumstances under 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
The scenario is this: you have a system where the transactions are small. As a result, you need very little Read More
In the last chapter, we briefly investigated the ORA-01555 error and looked at one cause of it: committing too frequently. Read More
This is a frequently asked but easily answered question. The presence of indexes (or the fact that a table is Read More
I get this question all of the time. You are getting warning messages to this effect (this will be found 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
In regard to undo generation, private temporary tables behave similar to global temporary tables. We can see that by running Read More