8.3. Using Automatic Routine Administration Tasks

The third element in the CMI is the automatic routine administration functionality designed into Oracle 10g. Recent surveys of database administrators show that most of them spend over 50 percent of their time on routine administration functions. In response, Oracle automated many of the most time-consuming tasks, leaving you with more time to focus on other issues.

In this section, we'll discuss the automatic statistics collection feature, which automates optimizer statistics collection and maintenance. You'll also be introduced to the automatic Database Manipulation Language (DML) monitoring functionality that detects stale statistics on database objects.

8.3.1. Automatic Statistics Collection ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.