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

On Sat, 01 Feb 2014 09:00:42 -0800, 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?
>
> The fact the client has a slower response time can be a sign the problem
> is on the client machine: how many applications are running on the
> client, how busy are the machine cpu's, how much free memory is there?,
> and what is the speed of the machine cpu's? Checking to see if other
> end users have better, worse, or equal performance may be worthwhile.
>
> HTH -- Mark D Powell --

He should run the performance trace (event 10046). That's the first thing to do in case of a performance problem.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com