Re: parallel query

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 14 Jul 1999 12:55:51 +0100
Message-ID: <931953825.1443.0.nnrp-10.9e984b29@news.demon.co.uk>

Yes, but the method varies with platform. On Unix boxes you can often get away with running the appropriate 'make' command in the $ORACLE_HOME/rdbms/lib directory.

Particular parameters: the easy trick is to do

    select name from v$parameter where name like 'para%';

parallel_min_server (default 0 - but you might want some permanently)
parallel_max_server (default 5 - but you might want a higher limit)
parallel_server_idle_time (default 10 - in minutes, before idle slaves die

back to 'min')

There are a couple of others, but the defaults are generally acceptable

There are a couple of items on PQO on my website. --

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

Tralyn wrote in message <931950517.11030_at_www.remarq.com>...
>Is it possible to install the parallel query option on top
>on an existing oracle install? Are there any specific
>parameters in the init file that I should pay attention too?
Received on Wed Jul 14 1999 - 06:55:51 CDT