SQL*Plus query hogs client CPU

From: hazledid <david.hazledine_at_roche.com>
Date: Tue, 11 May 1999 10:00:06 GMT
Message-ID: <GcTZ2.1766$xa.19209@c01read02-admin.service.talkway.com>

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 - 05:00:06 CDT