Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 7C40D1960FA8 for ; Thu, 6 Jun 2013 18:26:47 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Thu, 6 Jun 2013 18:26:47 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2089E22D7F; Thu, 6 Jun 2013 12:13:34 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org 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 Fw08lH2lyehc; Thu, 6 Jun 2013 12:13:33 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EDEAF22C41; Thu, 6 Jun 2013 12:12:52 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 06 Jun 2013 12:12:12 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ECA1922273 for ; Thu, 6 Jun 2013 12:12:11 -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 fOv0CPgrnaG0 for ; Thu, 6 Jun 2013 12:12:11 -0400 (EDT) Received: from blu0-omc4-s14.blu0.hotmail.com (blu0-omc4-s14.blu0.hotmail.com [65.55.111.153]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CE4C821665 for ; Thu, 6 Jun 2013 12:12:11 -0400 (EDT) Received: from BLU177-W1 ([65.55.111.135]) by blu0-omc4-s14.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 6 Jun 2013 09:25:20 -0700 X-TMN: [M/pd4VlHShToyb4zypFT989KNucOi8Pk] X-Originating-Email: [xiang_rao@hotmail.com] Message-ID: Content-type: text/plain From: Xiang Rao To: "Christopher.Taylor2@parallon.net" , "mohamed.houri@gmail.com" CC: "oracle-l@freelists.org" Subject: RE: Partitioned Explain Plan - Pstart/Pstop = KEY after execution Date: Thu, 6 Jun 2013 12:25:20 -0400 In-Reply-To: References: ,,, MIME-Version: 1.0 X-OriginalArrivalTime: 06 Jun 2013 16:25:20.0646 (UTC) FILETIME=[7043AA60:01CE62D2] Content-Transfer-Encoding: 8bit X-archive-position: 49211 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: xiang_rao@hotmail.com Precedence: normal Reply-To: xiang_rao@hotmail.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 Chris, > (Unless you're telling me that every partition will be touched in a partition pruning scenario anyway which I don't *think* would happen but perhaps it might) I have observed similar issues from some of our databases, for CTAS statements (Microstrategy reports). The tables are either range partitioned by multi columns or list, and parallel operations are used. For one case with list partition, the query uses sub query to specify partition key lists. I have been able to solve this one using PRECOMPUTE_SUBQUERY hint. Thanks. Xiang -- http://www.freelists.org/webpage/oracle-l