RE: 10g Automatic Statistics Gathering

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Wed, 6 Jul 2005 05:19:12 -0500 (EST)
Message-Id: <20050705154250.49B5642EC@node42.naturaljoin.lan>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Radoulov, Dimitre
Sent: Tuesday, July 05, 2005 17:47
To: Stephen.Barr_at_BSkyB.com; oracle-l_at_freelists.org 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    

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

Received on Wed Jul 06 2005 - 05:19:20 CDT