RE: 10g Automatic Statistics Gathering
- From: "Barr, Stephen" <Stephen.Barr@xxxxxxxxx>
- To: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>, Lex de Haan <lex.de.haan@xxxxxxxxxxxxxx>, "Barr, Stephen" <Stephen.Barr@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 5 Jul 2005 17:06:30 +0100
Thanks all! Much appreciated.
-----Original Message-----
From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx]
Sent: 05 July 2005 17:02
To: Lex de Haan; Stephen.Barr@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: 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
-----------------------------------------
Information in this email may be privileged, confidential and is intended
exclusively for the addressee. The views expressed may not be official
policy, but the personal views of the originator. If you have received it
in error, please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit, use or
disclose its contents to anyone. Please note we reserve the right to
monitor all e-mail communication through our internal and external
networks.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
