Chapter 10. Managing Database Performance

Up to this point, we've covered the basic topics of day-to-day database management. For the remainder of this book, we'll look at some of the more advanced topics in database administration, beginning with managing performance. At some point, every database administrator faces the problem where a user reports that "the database is slow." Where do we begin to tackle this problem? At the system level? The SQL statements themselves? Database parameters? Database performance tuning is perhaps the most intricate and complex of all the responsibilities of a DBA. Mastering it is a career-long pursuit that demands an in-depth understanding of the Oracle architecture. In the past (and perhaps still today), numerous ...

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.