RE: 10g Automatic Statistics Gathering

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Wed, 6 Jul 2005 03:55:53 -0500 (EST)
Message-Id: <20050705154029.44EE042CD@node42.naturaljoin.lan>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Barr, Stephen
Sent: Tuesday, July 05, 2005 17:36
To: oracle-l_at_freelists.org
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.

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

Received on Wed Jul 06 2005 - 03:56:18 CDT