RE: 10g Automatic Statistics Gathering

From: Barr, Stephen <Stephen.Barr_at_BSkyB.com>
Date: Tue, 5 Jul 2005 17:06:30 +0100
Message-ID: <4127F81F6CAFC245A18BC49054EFB06302EDE28A@ssslexchusr6.sssl.bskyb.com>

Thanks all! Much appreciated.

-----Original Message-----
From: Radoulov, Dimitre [mailto:cichomitiko_at_gmail.com] Sent: 05 July 2005 17:02
To: Lex de Haan; Stephen.Barr_at_BSkyB.com; oracle-l_at_freelists.org 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.

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

Received on Tue Jul 05 2005 - 11:08:57 CDT