Managing and Monitoring the Operational Database


This chapter deals primarily with the day-to-day management of Oracle databases and covers several major features that help you manage your database:
  1. Server-generated alerts are automatically raised by the database to let you know when problems occur.

  2. The Automatic Workload Repository (AWR) is the new infrastructure that automatically collects and maintains numerous performance statistics for self-tuning purposes. The Automatic Database Diagnostic Monitor (ADDM) that you saw in Chapter 17 uses the AWR data for its analyses.

  3. The Active Session History (ASH) deals with recent session activity, and the database uses it to tune its own performance.

  4. The advisory framework provides a common framework for various database advisors that supply information about resource utilization and performance. You’ve seen several of these advisors in other chapters, such as the ADDM, the SQL Access Advisor, and the SQL Tuning Advisor. I explain the common infrastructure of the advisory framework in this chapter.

  5. The DBMS_FILE_TRANSFER package lets you transfer operating system files directly through the database.

  6. The Oracle Scheduler provides a very powerful way to schedule complex database jobs.

  7. Automatic maintenance tasks take care of routine DBA tasks such as collecting optimizer statistics.

  8. The new diagnostic framework includes several tools, such as the Automatic Diagnostic Repository (ADR), the Support Workbench, incident packaging service (IPS), and the SQL Repair Advisor, that help you diagnose and repair database failures.



Database Link Remote Database Scheduler Agent Active Resource Plan Window Group 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati 2009

Personalised recommendations