O'Reilly logo

Oracle Database 11g New Features by Robert G. Freeman

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 9 Performance Tuning

Performance tuning in Oracle has always been an important part of the DBA's life. We have already discussed certain features such as Database Replay and the SQL Performance Analyzer (both in Chapter 5). This chapter covers more on Oracle Database 11g performance-related features. We look at improvements in monitoring Oracle Database-related processes, several statistics-related changes, SQL Plan Management, and several other new performance-tuning-related features in Oracle Database 11g. Now strap in, throttle up, and let's go ballistic!

Enhanced Oracle Process Monitoring

Sometimes an Oracle process (like SMON) will cause database performance-related issues. You can now identify the events that are causing the database ...

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