1. Administrator's Guide
  2. Optimizing Performance
  3. Tuning Oracle 11g Databases for Financial Management
  4. Tuning Guidelines for Oracle 11g Databases
  5. STATISTICS_LEVEL

STATISTICS_LEVEL

STATISTICS_LEVEL specifies the level of statistics collection for database and operating system. The Oracle database collects these statistics for a variety of purposes, including making self-management decisions. The default setting of TYPICAL ensures collection of all major statistics required for database self-management functionality, and provides the best overall performance.

Suggested setting: TYPICAL