From oracle-l-bounce@freelists.org Sun Mar 14 19:36:10 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2F1aAC28588 for ; Sun, 14 Mar 2004 19:36:10 -0600 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 i2F1a9o28582 for ; Sun, 14 Mar 2004 19:36:09 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B481F39088D; Sun, 14 Mar 2004 20:34:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 14 Mar 2004 20:33:38 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from web61108.mail.yahoo.com (web61108.mail.yahoo.com [216.155.196.110]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 35BCB3907D8 for ; Sun, 14 Mar 2004 20:33:37 -0500 (EST) Message-ID: <20040315013913.76054.qmail@web61108.mail.yahoo.com> Received: from [141.156.90.120] by web61108.mail.yahoo.com via HTTP; Sun, 14 Mar 2004 17:39:13 PST Date: Sun, 14 Mar 2004 17:39:13 -0800 (PST) From: Paula Winkler Subject: Re: dbms_stats.gather_schema_ To: oracle-l@freelists.org In-Reply-To: <20040314233655.69349.qmail@web61107.mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-574679153-1079314753=:75984" X-archive-position: 799 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: pw41972@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --0-574679153-1079314753=:75984 Content-Type: text/plain; charset=us-ascii Thank you Justin for your response. As far as I know, OPS is not required to gather statistics in parallel. The gather_schema specifications were recommended by a 3rd party software vendor. I'm testing gathering histograms for only indexed columns. However, because of the number of tables involved it is taking hours :-(. From: Justin Cave (DDBC) Date: Sun, 14 Mar 2004 16:48:01 -0700 Do you need to have Oracle Parallel Server for parallel operations to work in 8.1.7? I seem to recall having no problems with parallel statistics gathering in 8.1.7, but I had OPS installed. Do you really need to gather histograms on every column? That seems a bit excessive and probably is a substantial portion of your running time. Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam --0-574679153-1079314753=:75984 Content-Type: text/html; charset=us-ascii
Thank you Justin for your response.  As far as I know, OPS is not required to gather statistics in parallel.  The gather_schema specifications were recommended by a 3rd party software vendor.  I'm testing gathering histograms for only indexed columns.  However, because of the number of tables involved it is taking hours :-(. 
 
From: Justin Cave (DDBC) <jcave_at_ddbcinc.com>
Date: Sun, 14 Mar 2004 16:48:01 -0700

Do you need to have Oracle Parallel Server for parallel operations to work in 8.1.7? I seem to recall having no problems with parallel statistics gathering in 8.1.7, but I had OPS installed.  

Do you really need to gather histograms on every column? That seems a bit excessive and probably is a substantial portion of your running time.  

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC <http://www.ddbcinc.com/askDDBC>  

Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam --0-574679153-1079314753=:75984-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------