Re: Oracle 7.2.2 and PQO

In article <4equfv$mub_at_africa.cis.co.za>, heins_at_cis.co.za (Hein vd Merwe) wrote:

> In article <rp1399-2901961540260001_at_m12cim15.sps.mot.com>,
 rp1399_at_email.sps.mot.com (Steve Lemme) says:
> >
> >Beware Oracle 7.2.2.3 under HPUX as I think other platforms has a pretty
> >ugly Parallel Query bug. You should obtain Oracle 7.2.3 from Oracle
> >
> >Steve Lemme
> >DBA/Systems Manager
> >Motorola
> >
> >
> >
> >
> >
> >
> >In article <4e8rb7$ipj_at_africa.cis.co.za>, heins_at_cis.co.za (Hein vd
 Merwe) wrote:
> >
> >> Does anybody know how to determine the relationship
> >> between processes started by PQO from within Oracle
> >> ( V$ tables etc. ) ????
> >> I need to be able to determine the QUERY-COORDINATOR
> >> as well as what set of processes are busy with what.
> >> From the op-sys side it is reasonably easy but I need
> >> to do this programatically .
> >
> >--
> >When you are in it up to your ears....
> >Keep your mouth shut!
> >rp1399_at_email.sps.mot.com
>
>
> Hello Steve
>
> What PQO bug are you refering to ?
>
> Ive got a bug on a Sequent machine at the moment where as soon as
> Qeury servers are dynamically started to handle the load
> a Sequent error would occur on a "wait" statement or it
> would just hang and never come back.
> I have yet to get a selution from Oracle SA so if you have had this
> problem and it was fixed please e-mail me.
>
> Thanks Hein
>
> heins_at_cis.co.za

You should probably configure your system so that it doesn't dynamically allocate and de-allocate parallel query server processes, i.e. set parallel_min_servers equal to parallel_max_servers. There are known bugs with dynamic server allocation which probably haven't been fixed in 7.2.2.

   -Kevin J

-- 
~~~~~~~~~~~~ emergent: delivering scalable solutions ~~~~~~~~~~~~~~~
kevin jernigan                                      415-567-8915 (p)
emergent corporation                                415-265-0785 (c)
kjerniga_at_emergent.com   http://www.emergent.com     415-367-6414 (f)