Automated Maintenance Tasks in Oracle 11g
Oracle Database 11g comes with three predefined automatic maintenance tasks:
- The Automatic Optimizer Statistics Collection task collects statistics for all objects with no or stale statistics.
- The Automatic Segment Advisor task provides advice on which database segments have free space that can be reclaimed.
- Automatic SQL Tuning Advisor task, which examines SQL statement performance and makes SQL profile recommendations to improve the statements.
You can query the DBA_AUTOTASK_OPERATION to find out the names and status of the automatic tasks in your database. as shown in the following example:
1 2 3 4 5 6 7 |
SELECT client_name, status FROM dba_autotask_operation; CLIENT_NAME STATUS ---------------------------------------------------------------- -------- auto optimizer stats collection ENABLED auto space advisor ENABLED sql tuning advisor ENABLED |
These tasks are enabled by default.