Re: Oracle Parallel Server Option

In article <nd1ohZKs#GA.200_at_pet.hiwaay.net>,   "Shirley Kwan" <sskwan_at_ingr.com> wrote:
> Hi all,
>
> Does anyone have information about Parallel Server Option ???
> How can I implement it ?
> What's the basic system requirement ?
> What's the advantage of using Parallel Server Option ?
> .......
> --
> Shirley Kwan......
>

The Oracle Parallel Server product comes with the Enterprise edition of Oracle. In inorder to set it up you must have multiple hardware boxes from a vendor that supports shared file systems. With versions 7.0 - 7.3 you have to setup the hardware vendors DLM, distributed lock manager, and then you have to create the database with multiple instances. Oracle has taken over providing the DLM with either version 8 or 8.1.

One of the main advantages of OPS is failover. Should one machine have a hardware failure you shift the load to the other machine(s) providing you hold the load to 50% of machine capacity in a two box setup. Another is if you are approaching machine capacity you can add another, in theory cheaper, machine of the same type rather than upgrade to a bigger box. With recent advances in hardware capacity and reduction in cost I see the only real advantage being failover.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 07 1999 - 08:25:15 CDT