RE: 10g Automatic Statistics Gathering
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <Stephen.Barr@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Jul 2005 17:51:19 +0200
statistics collection in 10g is performed by the GATHER_STATS_JOB, which is part
of the AUTO_TASK_S_JOB_CLASS class, and scheduled with DBMS_SCHEDULER. This job
executes the DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC procedure as soon as the
MAINTENANCE_WINDOW_GROUP opens, typically during week nights and the weekend.
kind regards,
Lex.
------------------------------------------------------------------
Steve Adams Seminar <http://www.naturaljoin.nl/events/seminars.html>
http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Barr, Stephen
Sent: Tuesday, July 05, 2005 17:36
To: oracle-l@xxxxxxxxxxxxx
Subject: 10g Automatic Statistics Gathering
How do I stop Oracle automatically collecting statistics in 10g?
Does removing the EMD_MAINTENANCE job do this?
Thanks!
Steve.
_____
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.
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
Other related posts:
