Re: Oracle Parallel Server... multi processor machine

Hi Paul,
You are confusing Parallel Query (OPQ) and Parallel Server.(OPS) OPQ is for SMP machines, so one server with multiple CPUs OPS is about multiple servers having common disks, and using the same database.
This is done mainly for distribution of workload/failover/high availablity. So you would need to use OPQ, which is included in the Enterprise Edition. There won't be multiple instances
instead you need to configure your init.ora and/or your tables and/or your queries to use the multiple processors. If you don't do anything, the workload will be distributed using O/S mechanisms, if available.

Hth,

--
Sybrand Bakker, Oracle DBA
Paul Bennett <bennett_at_cc.gatech.edu> wrote in message news:3859322E.7E4BBFD0_at_cc.gatech.edu...
> Not counting writing the application for using a parralel server
> effectivly, if I wanted to run oracle on a multi processor machine I
> would need to use oracle parallel server, correct? If so, if I had 8
> processors, I would run 8 instances? If so, would each instance have an
> SGA? If so, isn't that a waste of memory to potential have the same
> table data cached in serveral SGA's on the same machine? Is there a way
> to share that buffer pool?
>
> It makes sence to have an SGA for each instance if the instances are
> running on completely different machines, of course.
>
> Thanks
>
> -- Paul
>
Received on Thu Dec 16 1999 - 13:58:28 CST