Re: SQL*Plus query hogs client CPU

Some things to look at:

Use the Perfmon program and look at what is sucking memory - it may not be SQL*Plus. There may be some background processes running on the slower workstation that are not on the faster workstation. Have your network guys take a look utilization on the network segments if the two workstations are on a different collision domain. Consider the possibility of a chattering NIC Do both workstations have the same amount of RAM? Is the slower workstation doing a paging to the swap file?

Since almost all of the actual work is done on the Oracle server, you shouldn't see such a big difference.

hazledid wrote:

> We've seen some very odd behaviour with long running SQL*Plus queries
> and I wondered if anyone can shed some light on it.
>
> A query which takes 40 mins to complete when run on a fast client takes
> 4-5 times longer when run on a slower client. The versions of
> SQL*Plus, SQL*Net and NT on the clients are the same, both clients
> are accessing the same remote database server, and the amount of data
> returned by the query is small (so network bandwidth can't be a
> limiting factor). Observing the slower client with NT Task Manager
> while the query is running, I see CPU utilisation consistently hitting
> 100%.
>
> This would explain why the query completes more quickly on a faster
> client, but why is SQL*Plus consuming client-side CPU resources at all?
> Surely in the wonderful world of client/server
> all the work in a case like this should be done on the server?
>
> All very mystifying...
>
> In case it's relevant, the software versions are: NT 4.0, SQL*Plus
> 3.3.0, SQL*Net 3.3.0, Oracle 7.3.3.4
>
> David J. Hazledine
> Roche Products Limited
> 40 Broadwater Road
> Welwyn Garden City
> AL7 3AY
> United Kingdom
> Registration Number 100674
> Tel. +44 (0)1707 366166
> --
> Posted via Talkway - http://www.talkway.com
> Exchange ideas on practically anything (tm).
Received on Tue May 11 1999 - 23:13:40 CDT