From oracle-l-bounce@freelists.org Mon Apr 5 13:21:20 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i35ILKP05460 for ; Mon, 5 Apr 2004 13:21:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i35ILJo05455 for ; Mon, 5 Apr 2004 13:21:19 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B087A634D25; Mon, 5 Apr 2004 13:17:01 -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 27254-35; Mon, 5 Apr 2004 13:17:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BC1A4634E18; Mon, 5 Apr 2004 13:16:55 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 05 Apr 2004 13:15:43 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D67D7634DD1 for ; Mon, 5 Apr 2004 13:15:42 -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 26247-100 for ; Mon, 5 Apr 2004 13:15:42 -0500 (EST) Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.198.35]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6386A634DDE for ; Mon, 5 Apr 2004 13:15:42 -0500 (EST) Received: from 204.127.197.115 ([204.127.197.115]) by comcast.net (rwcrmhc11) with SMTP id <20040405182447013000v2g2e>; Mon, 5 Apr 2004 18:24:47 +0000 Received: from [67.65.91.34] by 204.127.197.115; Mon, 05 Apr 2004 18:24:46 +0000 From: thump604@comcast.net To: oracle-l@freelists.org Cc: "Cary Millsap X-Mailer: AT&T Message Center Version 1 (Mar 22 2004) X-Authenticated-Sender: dGh1bXA2MDRAY29tY2FzdC5uZXQ= X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2555 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thump604@comcast.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org dbms_stats.gather_database_stats I can't locate the 8174 docs now that Technet is such a mess, but I recall this package not only analyzes sys/system objects but also collects IO stats. I think it is IO stats collected and not CPU stats. It is one of the other, I'm pretty sure. Anyway, has anyone played around with gathering database stats in 8174 in order to gather the collected resource stats and then delete stats on the dictionary tables that have been related to bugs and statistics in 8174? I'm wondering if this might help with accurate costing. -- - David > Yep, "bug" is where we're going with it... But we haven't had time yet > to go into detail. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > * Nullius in verba * ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------