Re: Parralelizing Oracle processes

Oh, also, you should check the administration manuals to set up controls for the maximum and minimum number of Parallel Query servers, how many you wish to be prestarted and persist when the instance starts, how many more you wish to allow to be spawned, and such; otherwise PQ won't ever come up. (And yes, you do need Oracle Enterprise Edition or OPQ won't work at all.)

OPQ should never be confused with OPS (Oracle Parallel Server) or the newer clustering product. PQ allows multiple processors on the same machine to decompose and work on a query; OPS / etc permit you to group servers together to go after data stored on a common mass storage resource.

Which is not to say that you may not make use of both PQ (multiple processors on a server) and PS (multiple servers) techniques to address a particular issue.

RSH.
"Frederic Payant" <fpayant_at_club-internet.fr> wrote in message news:bur8cus0c9gvhtu61q9gauk4khs0o6v1qm_at_4ax.com...
> Hi,
>
> I've a little problem with Oracle 817 on Solaris : Is it parallel. I
> mean : all documentation, about orders, packages, init files seems to
> meet the idea that, by default, Oracle always parallelize operations,
> big scans, statistics and so on.
> But when I launch large jobs or stats, I very well see that these jobs
> are all done by one single processor (I currently work on a 8 procs
> domain).
> Did I miss something in doc; Must I set any parameter ? Is it becaus I
> use a 32bits version of Oracle ?
>
> Any info will be welcome (and don't hesitate to ask me any further
> information if needed)
>
> Thanks a lot
>
> Regards
> Frederic PAYANT - junior DBA ;-)
Received on Mon Apr 22 2002 - 17:27:25 CDT