Chapter 10. Diagnosing the Database and Managing Performance

ORACLE DATABASE 11g: ADMINISTRATION II EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Diagnosing the Database

    • Set up Automatic Diagnostic Repository

    • Using Support Workbench

    • Perform block media recovery

  • Managing Database Performance

    • Use the SQL Tuning Advisor

    • Use the SQL Access Advisor to tune a workload

    • Understand Database Replay

Diagnosing the Database and Managing Performance

This chapter is divided into two sections; the first section is dedicated to tools that help the DBA diagnose problems in the database, and the second part is dedicated to tools that assist with detecting and resolving performance issues.

In the first part, we introduce the Automatic ...

Get OCP: Oracle Database 11g Administrator Certified Professional Study 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.

Start your free trial