From oracle-l-bounce@freelists.org Thu Mar 3 13:07:01 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j23J71b4015623 for ; Thu, 3 Mar 2005 13:07:01 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j23J6xem015617 for ; Thu, 3 Mar 2005 13:06:59 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1DEFE7DDB0; Thu, 3 Mar 2005 12:51:14 -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 16516-04; Thu, 3 Mar 2005 12:51:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 91BAF7E17C; Thu, 3 Mar 2005 12:51:13 -0500 (EST) Date: Thu, 03 Mar 2005 18:49:26 +0100 From: jo_holvoet@amis.com Subject: RE: Different execution plans for same query with same cost To: oracle-l@freelists.org Message-id: MIME-version: 1.0 Content-type: text/plain; charset=us-ascii X-MIMETrack: Serialize by Router on MailEU/AMI(Release 5.0.12 |February 13, 2003) at 03/03/2005 18:49:27, Serialize complete at 03/03/2005 18:49:27 Content-Transfer-Encoding: 8bit X-archive-position: 16900 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jo_holvoet@amis.com Precedence: normal Reply-To: jo_holvoet@amis.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.3 required=5.0 tests=NO_REAL_NAME autolearn=no version=2.60 X-Spam-Level: Nope, no RLS. But as I've replied to others, cursor_sharing=force. mvg/regards Jo "Powell, Mark D" Sent by: oracle-l-bounce@freelists.org 03/03/2005 18:22 Please respond to mark.powell To: oracle-l@freelists.org cc: Subject: RE: Different execution plans for same query with same cost Depending on exactly what you mean by the same query since you give no details on the query itself could the results you are seeing be the results of bind variable peeking? Is RLS in use on this DB? HTH -- Mark D Powell -- -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l