Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 18798 invoked from network); 28 Mar 2008 10:33:36 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 28 Mar 2008 10:33:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D2D89832390; Fri, 28 Mar 2008 11:33:34 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08808-04; Fri, 28 Mar 2008 11:33:34 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 570BD832386; Fri, 28 Mar 2008 11:33:34 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 28 Mar 2008 10:56:03 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5BCD5831547 for ; Fri, 28 Mar 2008 10:56:03 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03114-03 for ; Fri, 28 Mar 2008 10:56:03 -0400 (EDT) Received: from web80608.mail.mud.yahoo.com (web80608.mail.mud.yahoo.com [209.191.72.78]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 048B8830BD6 for ; Fri, 28 Mar 2008 10:56:02 -0400 (EDT) Received: (qmail 18517 invoked by uid 60001); 28 Mar 2008 14:56:01 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=3jsbX5VMedxxyhHGqTEzT+LmQWoE9Y6y2pcKRdLt7QlwzSJXDLCcUh1A/p6pJLMT6c9Ki8d4Sj5GNdiElXX/g/p5v+R+7MaVfgI75ceBQSOF12T7EZsNS9oRmBJEYb5Ba2K6rcWMDuipStdPOJqsSnI4Uevj5I2LM5bqk5gYIlA=; X-YMail-OSG: YWm2ygcVM1nryIQtCDUSrGhcJnE3K1pQGOvF4DwL.KWfQoNaWgKTrC74N0ssh0Xh6bY5.fMUGcd98AKYsr7PKnP6uTDMsCf9re9HxfdGzvQHumw5y.0- Received: from [143.111.22.24] by web80608.mail.mud.yahoo.com via HTTP; Fri, 28 Mar 2008 07:56:01 PDT Date: Fri, 28 Mar 2008 07:56:01 -0700 (PDT) From: Yong Huang Subject: Re: create a view with parallel hint To: oracle-l@freelists.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Message-ID: <869900.18031.qm@web80608.mail.mud.yahoo.com> X-archive-position: 6682 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: yong321@yahoo.com Precedence: normal Reply-to: yong321@yahoo.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: Debian amavisd-new at localhost.localdomain > I can't change the tables parallelism,.. too much impact on the rest > of the system. Too risky. Tony, How about you change the table parallel degree right before you submit the report job and immediately change it to noparallel after it? You just need to fool the CBO into thinking the table is paralleled during parsing. The impact would be limited to the SQLs freshly parsed during that few second window (so they also thought the table was parallel), as well as causing some hard parses later for other SQLs (but they get the original plans). Not directly related to this. If you pull a lot of data across wire, make sure you increase arraysize (Fetch Buffer Size in ODBC). It makes dramatic improvement. Yong Huang ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs -- http://www.freelists.org/webpage/oracle-l