Re: Parallel Query Option

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 4 Oct 1999 22:20:23 +0100
Message-ID: <939072105.4313.0.nnrp-04.9e984b29@news.demon.co.uk>

There are a couple of papers on my web site about parallel query.

If you have init.ora parallel_min_servers = 0, then any PQ slaves (Pnnn) will die after a few minutes; if you have parallel_max_servers=0 then you will never get any anyway

Also you need some tables declared as parallel, or some SQL with hints to get parallel execution, and then you need the tables to be reasonably large, or Oracle may choose to execute serially.

(I don't think I've miss any obvious points, but if I have, they'll be in the papers).

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

andres wrote in message ...
>Hi everybody:
>
>How do I know if the Parallel Query Option is properly set up in my
>database?
>I'm using Oracle 7.3.4 with Financials Applications 10.7. I've queried
>V$PQ_SYSSTAT but all I got is zeroes in the value column.
>When I ps -ef | grep ora_ I don't get the Pxxxx background process for P.
Q.
>
>Best regards, Andres
>
>
Received on Mon Oct 04 1999 - 16:20:23 CDT