RE: 10g Automatic Statistics Gathering
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <cichomitiko@xxxxxxxxx>, <Stephen.Barr@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Jul 2005 17:53:40 +0200
be careful, though --
STATISTICS_LEVEL behaves pretty much as a "main switch" for many 10g features.
you might inadvertently disable more features than desired ...
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 Radoulov, Dimitre
Sent: Tuesday, July 05, 2005 17:47
To: Stephen.Barr@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: 10g Automatic Statistics Gathering
>> How do I stop Oracle automatically collecting statistics in 10g?
You need to set the statistics_level=basic in the init.ora or spfile. This will
disable the automatic statistic gathering feature of 10g.
HTH
Dimitre
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:
