From oracle-l-bounce@freelists.org Tue Jul 5 10:49:15 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j65FnFld031608 for ; Tue, 5 Jul 2005 10:49:15 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j65FnEIP031596 for ; Tue, 5 Jul 2005 10:49:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 81E671C8712; Tue, 5 Jul 2005 10:49:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24897-04; Tue, 5 Jul 2005 10:49:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0A88F1C8966; Tue, 5 Jul 2005 10:49:10 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:from:to:references:subject:date:mime-version:content-type:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=hdlohfy/ogtLF1rfWTNFgN+h+xJhS8SdNTjUcc9zVMauRlUlWicBJYmwAbGqQ8YZkx1c69r2Z9hCPpGXGxenwZYpWeUcys9o2SzGCNslchYfvQoJhJ3JPkJr4mhiWTTdTRLj6+Ar1zYgSiyy2MqGUu/72G5nZ/Vhy65j2P8oVEA= Message-ID: <037e01c58178$d751fb60$1a03310a@IBME1D11967173> From: "Radoulov, Dimitre" To: , References: <4127F81F6CAFC245A18BC49054EFB06302EDE24F@ssslexchusr6.sssl.bskyb.com> Subject: Re: 10g Automatic Statistics Gathering Date: Tue, 5 Jul 2005 17:47:23 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_037B_01C58189.99B6E4D0" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-archive-position: 22058 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cichomitiko@gmail.com Precedence: normal Reply-To: cichomitiko@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.9 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_037B_01C58189.99B6E4D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable >> How do I stop Oracle automatically collecting statistics in 10g? You need to set the statistics_level=3Dbasic in the init.ora or spfile. = This will disable the automatic statistic gathering feature of 10g.=20 HTH Dimitre=20 ------=_NextPart_000_037B_01C58189.99B6E4D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

>> How do I stop = Oracle=20 automatically collecting statistics in = 10g?

You need to set the statistics_level=3Dbasic in the init.ora or = spfile. This=20 will disable the automatic statistic gathering feature of 10g.

HTH
Dimitre

------=_NextPart_000_037B_01C58189.99B6E4D0-- -- http://www.freelists.org/webpage/oracle-l