Re: Oracle threading on HP (load balancing

On Thu, 03 Sep 1998 15:07:20 GMT, rad_at_earthling.net <rad_at_earthling.net> wrote:
>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%).

Sometimes I wonder about glance. It just doesn't seem to always jive with other tools.

>
>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

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Sep 03 1998 - 17:25:57 CDT