Re: Oracle Parallel Server - What is it ?

davesl_at_aladdin.co.uk (Dave Slade) wrote:
>Hi all,
>
>I understand there is a form of an Oracle Database server described as
>'Parallel'. Does anybody, in general, know what this is; and what
>does it give above a standard system (If there is such a thing!) ?
>
>I could take a couple of guesses I suppose - maybe something along the
>lines of fault tolerance/performance ??
>
Right, to put it simply. It allows you to have multiple instances (usually running on different nodes of a cluster) to open the same database. If one node fails, you can go on working on the others. If you need more CPU power, you can add a node. If you also have parallel query, you can have Oracle split queries over several instances (and therefore CPUs).

>Is this beast a special version of the basic DBMS software or is it
>some kind of 'add-on' software which allows colaboration of different
>machines/instances ?
>

It's an option, like, say, the distributed option, or the parallel query option. You buy it, and you install it the normal way, using orainst. Then you STARTUP PARALLEL your instances. OPS uses the gc_* init.ora parameters.

>Any info welcome - Many thanks
>
>Dave
>
>------------------------------
>Dave Slade ( davesl_at_aladdin.co.uk )
>
>Hampshire, UK.
>------------------------------
>

Regards

     Pedro Received on Tue Aug 01 1995 - 00:00:00 CEST