Re: Oracle's performance on 4 CPU Server

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Wed, 15 May 2002 00:04:49 +0200
Message-ID: <ba23eu8ugfn1ip351rlo22j08c49aornqo@4ax.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>Oracle will only play 'Divide and Conquer' with multiple CPUs if Parallel
>Query is installed and Parallel Query is only available with the Enterprise
>Edition.
>If you have Oracle Standard, 'Divide and Conquer' is subject to any
>algorithms present in Solaris and/or pbind commands you explicitly gave.
>So if you have Standard it is pretty much end of story. Apart from 'binding'
>a process to a specific CPU you can't do anything.
>

We use Oracle EE 8.1.7. How can I find out if the Parallel Query option is installed? Quick and dirty?

Thanks
Rick Received on Tue May 14 2002 - 17:04:49 CDT