Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Several CPUs and the parallel option
Rick
I think Steve may have identified the clincher here. Oracle Parallel Server (OPS) is completely different to Parallel Query Option (PQO) (though I think it's had a name change in Ora9???).
To get the app to make use of PQO, you can do one of several things - I can think of two extremes
Remember that you'll need to have data in multiple extents before Oracle can use PQO - each PQO server is given an extent to work. Realistically though to get the best performance you'll want to spread the data over as many disks as possible using Oracle or OS stripping.
Andy
"Steve" <smontgomerie_at_hotmail.com> wrote in message
news:156709aa.0207290435.68932bda_at_posting.google.com...
> > When I start instance, I get a message "...with the parallel option".
> > But when I set the parallel option on in the init.ora file, the
> > instance won't start.
> >
>
> you're not trying to start up with parllel_server = true are you? If
> so this is OPS/RAC and is a different ball game then paralle query
> option (pwo)
>
> steve
Received on Mon Jul 29 2002 - 10:58:13 CDT