Re: Oracle's performance on 4 CPU Server

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:ba23eu8ugfn1ip351rlo22j08c49aornqo_at_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

should be in the banner (v$version) and in v$option. However if parallel_min_servers and parallel_max_servers init.ora parameters are 0, you don't use it.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address