Re: Oracle threading on HP (load balancing

From: <rad_at_earthling.net>
Date: Thu, 03 Sep 1998 15:07:20 GMT
Message-ID: <6smbb8$j5o$1@nnrp1.dejanews.com>

In article <01bdd65b$ef832800$0300a8c0_at_WORKSTATION>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

> I would have assumed that a single process could use
> only a single processor - the fact that s000 is running at
> 100% ( is this all the time or intermittently) suggests that
> the session that is in the Oracle virtual circuit is working
> very hard on an SQL statement (or PL/SQL procedure) that
> is a candidate for tuning.

The problem is intermittent but common. And it's always s000 that becomes 100% bound. There are up to six shared servers but s000 will become 100% CPU bound (according to glance) yet the others are often below 5% (or even 0%).

PQO also doesn't appear to load balance the way we expect it to. One process seems to take the load while the others sit fairly idle.

HP 6-way T520
HPUX 10.2
Oracle 7.3.4

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 03 1998 - 10:07:20 CDT