Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feeder1.cambriumusenet.nl!82.197.223.108.MISMATCH!feeder2.cambriumusenet.nl!feed.tweaknews.nl!195.62.100.242.MISMATCH!newsfeed.kamp.net!newsfeed.kamp.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Noons <wizofoz2k@yahoo.com.au>
Newsgroups: comp.databases.oracle.server
Subject: Re: Significant difference in response times for same query running
 on Windows client vs database server
Date: Sun, 02 Feb 2014 19:29:58 +1100
Organization: NOYB
Lines: 11
Message-ID: <lckvm9$v13$1@dont-email.me>
References: <752cfcd9-b397-4838-826f-a955be32110b@googlegroups.com> <4826df4e-2e95-469e-aef6-0b30ab72e978@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Sun, 2 Feb 2014 08:30:02 +0000 (UTC)
Injection-Info: mx05.eternal-september.org; posting-host="c88b951674d27358033d0062ad06fd2b";
 logging-data="31779"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX196RZpnPhuUPKp5vIHCL00v"
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130215 Thunderbird/17.0.3
In-Reply-To: <4826df4e-2e95-469e-aef6-0b30ab72e978@googlegroups.com>
Cancel-Lock: sha1:CsNHR2eEjzHzNnm/LdCS04JgOzE=
Xref:  news.cambrium.nl

On 2/02/2014 4:00 AM, Mark D Powell wrote:

>

> mjm, you should capture the session that is running from the client
> and compare the plan in v$sql_plan to what you posted.  Why is the
> SQL using a First_Rows hint?

Didn't he just say the plans are the same?:
">> In both cases the query plans are the same."