Re: 10g Automatic Statistics Gathering

Thanks Lex!
So in situations when you want to disable automatic statistics gathering, the most direct approach is to disable the GATHER_STATS_JOB as follows(Concepts Guide 10G r1):

BEGIN
  DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB'); END;
/

Setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important statistics required by Oracle Database features and functionality, including:
Automatic Workload Repository (AWR) Snapshots Automatic Database Diagnostic Monitor (ADDM) All server-generated alerts
Automatic SGA Memory Management
Automatic optimizer statistics collection Object level statistics
End to End Application Tracing (V$CLIENT_STATS) Database time distribution statistics (V$SESS_TIME_MODEL and V$SYS_TIME_MODEL)
Service level statistics
Buffer cache advisory
MTTR advisory
Shared pool sizing advisory
Segment level statistics
PGA Target advisory
Timed statistics
Monitoring of statistics

Note:
Oracle strongly recommends that you do not disable these important features and functionality.

Cheers
Dimitre Radoulov

ETNØTEAM

--
http://www.freelists.org/webpage/oracle-l