Re: Significant difference in response times for same query running on Windows client vs database server

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?

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