Chapter 14. Maintaining the Database and Managing Performance

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

  • Database Maintenance

    • Use and manage Optimizer Statistics

    • Use and manage Automatic Workload Repository (AWR)

    • Use Advisory Framework

    • Manage Alerts and Thresholds

  • Performance Management

    • Use Automatic Memory Management

    • Use Memory Advisors

    • Troubleshoot invalid and unusable objects

Maintaining the Database and Managing Performance

Successful database administrators are always on the lookout for potential database problems that could adversely impact the availability or performance of the systems they manage. Fortunately, Oracle 11g comes with an array for proactive performance ...

Get OCA Oracle® Database 11g Administrator Certified Associate: 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