CHAPTER7
Managing 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 also ensuring that DML statements will not fail.
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 ...
Get Oracle Database 12c 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.
