Chapter 8. Managing Concurrency
One of the most difficult challenges that the real-world DBA faces is performance tuning. Performance tuning is the process of using database configuration mechanisms to achieve optimal application throughput. It is a career-long study that requires a keen understanding of the way that a database works, from memory caches to process configuration to the topic of this chapter—concurrency. Concurrency is the property that enables systems with many competing resources to function optimally. Maintaining concurrency in the Oracle RDBMS involves rules, mechanisms, and configuration settings.
In this chapter we shall:
- Understand the lifecycle of a transaction
- Explain the concept of the undo process
- Learn to manage undo data ...
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.
