O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required