Re: Oracle Parallel Server... multi processor machine

From: Theodore V. Reh <mattie11_at_ameriteh.net>
Date: Thu, 16 Dec 1999 19:44:40 -0500
Message-ID: <38598778.E3215816@ameriteh.net>

No. Oracle Parallel Server (OPS) instances (plural) are run from physically different boxes sharing the same database usually stored on RAW space.

Oracle can utilize the 8 cpu's with parallel processing by setting the appropriate init.ora parameters in exlusive mode. OPS is a completely different beast.

TR-

Paul Bennett wrote:

> 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 - 18:44:40 CST