Re: 10g Automatic Statistics Gathering
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>, <Stephen.Barr@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Jul 2005 18:02:09 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: