CHAPTER 7Managing Transactions with Undo Tablespaces

In Chapter 6, we touched briefly on how the space in an undo tablespace is managed, along with views such as V$UNDOSTAT that can help the DBA monitor and size the undo tablespace. In this chapter, we'll delve much more deeply into the configuration and management of the undo tablespace, and how we may resolve the sometimes conflicting requirements of providing enough undo for read consistency while preventing the failure of DML statements because the undo retention parameter is set too high.

To start off this chapter, we'll do a quick review of transactions from a database user's point of view so that you will better understand how to support the user's transactions with the appropriately sized ...

Get Oracle Database 11g DBA Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.