Summary

In this chapter, we've examined the principles and practices behind maintaining good levels of concurrency in the database. We've explored the lifecycle of a transaction and introduced the concept of undo data. We've learned how to manage this undo data in an undo tablespace and use database parameters to enable Automatic Undo Management. Finally, we've examined database serialization mechanisms, including locks, latches, and mutexes. In our next chapter, we explore an entirely new subject—the way networking operates in Oracle.

Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide 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.