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 ...
Get Oracle Database 11g New Features 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.
