Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.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: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: Significant difference in response times for same query running on Windows client vs database server Date: Sun, 2 Feb 2014 17:07:09 +0000 (UTC) Organization: A noiseless patient Spider Lines: 27 Message-ID: References: <752cfcd9-b397-4838-826f-a955be32110b@googlegroups.com> <4826df4e-2e95-469e-aef6-0b30ab72e978@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Sun, 2 Feb 2014 17:07:09 +0000 (UTC) Injection-Info: mx05.eternal-september.org; posting-host="9329a606497bb546bacd1416e46e9713"; logging-data="5821"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/gSHaX0Szv2c8pb9hMYbNy" User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) Cancel-Lock: sha1:XNn/IfHGZvpwtshjE/KLa13Bo7k= Xref: news.cambrium.nl On Sun, 02 Feb 2014 19:29:58 +1100, Noons wrote: > 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." And that eliminates the plan as a possible culprit. We may have to look at the butler, or the network but we need more clues, like the trace file. The execution plan is meaningless, since the problem obviously isn't in the plan. The OP needs to activate the event 10046, level 12, execute the SQL over the network and analyze the resulting trace file. The file itself would probably be too large for posting on this group but the summary by tkprof or orasrp would fit just fine. -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com