Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 31299 invoked from network); 12 Dec 2006 14:11:48 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 12 Dec 2006 14:11:48 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9D9D95681CA; Tue, 12 Dec 2006 15:10:43 -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 08393-02-2; Tue, 12 Dec 2006 15:10:43 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0D5AC566BD3; Tue, 12 Dec 2006 15:10:42 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 12 Dec 2006 15:09:37 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A4B8656750A for ; Tue, 12 Dec 2006 15:09:37 -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 08081-02 for ; Tue, 12 Dec 2006 15:09:37 -0500 (EST) Received: from mx02.il.proquest.com (mx02.il.proquest.com [192.195.245.52]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 834905656D8 for ; Tue, 12 Dec 2006 15:09:37 -0500 (EST) X-ASG-Debug-ID: 1165954232-7b0d01070000-JbYmij X-Barracuda-URL: http://spam.il.proquest.com:8000/cgi-bin/mark.cgi X-Barracuda-Connect: aabo-exchange05.bos.il.pqe[172.24.3.61] X-Barracuda-Start-Time: 1165954232 X-ASG-Whitelist: Client Received: from aabo-exchange05.bos.il.pqe (aabo-exchange05.bos.il.pqe [172.24.3.61]) by mx02.il.proquest.com (Spam Firewall) with ESMTP id 1512211A590; Tue, 12 Dec 2006 15:10:32 -0500 (EST) Received: from AABO-EXCHANGE02.bos.il.pqe ([172.24.3.206]) by aabo-exchange05.bos.il.pqe with Microsoft SMTPSVC(6.0.3790.1830); Tue, 12 Dec 2006 15:10:31 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-ASG-Orig-Subj: RE: Updating system statistics Subject: RE: Updating system statistics Date: Tue, 12 Dec 2006 15:09:39 -0500 Message-ID: In-Reply-To: <716f7a630612121202p79f20674yc61d54bd64119bb4@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Updating system statistics From: "Bobak, Mark" To: , "Christian Antognini" Cc: X-OriginalArrivalTime: 12 Dec 2006 20:10:31.0951 (UTC) FILETIME=[937131F0:01C71E29] X-Barracuda-Virus-Scanned: by Barracuda Spam Firewall at il.proquest.com X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=3.5 QUARANTINE_LEVEL=5.0 KILL_LEVEL=8.0 X-archive-position: 43076 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-to: Mark.Bobak@il.proquest.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net Don, I don't think it will run asynchonously. I think the problem is that you didn't specify gathering_mode, and it defaults to NOWORKLOAD, which means the interval you specified was ignored. Try adding: gathering_mode=>'INTERVAL' to the argument list and run it again. -Mark -- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning There is nothing so useless as doing efficiently that which shouldn't be done at all. -Peter F. Drucker, 1909-2005 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Don Seiler Sent: Tuesday, December 12, 2006 3:03 PM To: Christian Antognini Cc: oracle-l@freelists.org Subject: Re: Updating system statistics Alright I ran this command: exec dbms_stats.gather_system_stats(interval=>90,stattab=>'SYSSTATS',statid=> 'DEC12'); It returned in a minute, so I assume that it runs in the background now. I've noticed two rows in my SYSSTATS table, but the column names are a bit unintuitive. Is there a HOWTO on interpreting that data? Don. On 12/12/06, Christian Antognini wrote: > > > So gathering system stats to the user table won't alter CBO behavior > > then? I assume I have to create that table with > > dbms_stats.create_stat_table() function. > > Exactly. > -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l