Re: Is Parallel Query installed?

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Fri, 18 Jun 1999 09:52:42 +0200
Message-ID: <7kctqj$gia$1@korweta.task.gda.pl>

Doug Cowles wrote in message <3769C1BA.FA3F32DD_at_bigfoot.com>...
>I do not see Parallel Query in the v$option listing. However, I can
>alter a table to parallel n, so I am pretty sure it's there, pending
>some wierdness.

Yup. And if you have bad luck you'll see wierdness with optimization paths enforcing hash joins and other new feature stuff at every join. Storage parameters are independent from options installed. Even optimizer doesn't know whether parallel query option is installed and in case of non-default parallel clause on table it assumes cost based optimization and produces plan for parallel-query (in 7.3.4 for example).

--
Piotr Kolodziej pkol_at_otago.gda.pl
Just my private opinion. Received on Fri Jun 18 1999 - 02:52:42 CDT