A New Performance Philosophy

While Oracle Database 10g has introduced major changes in many areas, there has been significant improvement in the area of performance monitoring and tuning. Indeed, the philosophy in this RDBMS version has been one of automation, a philosophy that has been fully implemented in this important component.

Traditionally, the Oracle RDBMS has not suffered from nonavailability of detailed performance statistics. Rather, users have lacked both a consistent method of easily exposing and using these performance statistics, as well as tools that analyzed these statistics and provided sane advice. Although the aptly named Oracle Wait Interface has existed since Oracle 7.0, only after the turn of the century has it become popular ...

Get Oracle® Database 10g Insider Solutions 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.