Re: Oracle Parallel Server... multi processor machine

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 16 Dec 1999 11:30:03 -0800
Message-ID: <38593DBB.C1A903F9@us.oracle.com>

No, you don't need Parallel Server for this. Parallel Server is used in a multi-node configuration for high availability and/or performance reasons.

Oracle will automatically take advantage of multi-CPU systems. However, you may want to look at Parallel Query to get optimal performance.

HTH. Pete

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 - 13:30:03 CST