From oracle-l-bounce@freelists.org Wed Jan 18 04:37:46 2006 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id k0IAbkIN000521 for ; Wed, 18 Jan 2006 04:37:46 -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 k0IAbjg7000513 for ; Wed, 18 Jan 2006 04:37:45 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E7A6927C243; Wed, 18 Jan 2006 05:37:40 -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 15619-03; Wed, 18 Jan 2006 05:37:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 70F8827C244; Wed, 18 Jan 2006 05:37:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 18 Jan 2006 05:37:31 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 33AE627C0BA for ; Wed, 18 Jan 2006 05:37:31 -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 15564-03 for ; Wed, 18 Jan 2006 05:37:31 -0500 (EST) Received: from romy.inter.net.il (romy.inter.net.il [192.114.186.66]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A616A27AC71 for ; Wed, 18 Jan 2006 05:37:30 -0500 (EST) Received: from [192.168.0.14] ([212.68.138.137]) by romy.inter.net.il (MOS 3.7.3-GA) with ESMTP id DJV75341 (AUTH adar76); Wed, 18 Jan 2006 12:37:25 +0200 (IST) Message-ID: <43CE19F7.1080305@inter.net.il> Date: Wed, 18 Jan 2006 12:35:35 +0200 From: Yechiel Adar User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: Oracle-L Subject: Re: Two users, one query, two optimizer plans References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-archive-position: 30138 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: adar76@inter.net.il Precedence: normal Reply-To: adar76@inter.net.il X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org Mu guess is that dm_issuegrant_ix01 is a function based index designed to apply to: hextoraw(value). When user A run there is no where clause that fits the index, so full table scan. Have you tried doing the select with the same where clause (including hextoraw) from user A? Adar Yechiel Rechovot, Israel Paul Baumgartel wrote: > > For each table subject to row-level security policy, the RLS view is > of the form > > SELECT FROM WHERE company_fk in (hextoraw('') > > My theory at this point is that RLS is causing the discrepancy in > optimizer plans. Has anyone seen this? Is there another reason why > the plans would differ? > > Thanks, > > > -- > Paul Baumgartel > paul.baumgartel@aya.yale.edu > -- http://www.freelists.org/webpage/oracle-l