Re: Configuring Oracle for an SMP machine

Actually is the Parallel Query Option that takes advantage of multiple processors on a single machine. The Parallel Server Option is so that instances on two or more machines can work on the same database. To see if you have the Parallel uery Option installed look at the banner when you invoke Server Manager (svrmgrl).

On Thu, 18 Dec 1997 15:34:59 -0700, Pinchas Nisenson <nisenson_at_acs.ucalgary.ca> wrote:

>If I am not mistaken you have to install the Oracle parallel server
>option. The reason for my assumption is that while installing Oracle on
>a single processor RS 600 server I by mistake chose the parallel server
>option and as a result I got an Oracle error message telling me that
>there is only one processor found.
>=========================
>
>C. Mason wrote:
>>
>> We are running ORACLE 7.3.3 on an IBM RS6000 SMP machine with 4 processors.
>> I used the same install that I used on other IBM RS6000 machines that are
>> single processors. So, unless there are major differences on your platform,
>> I don't believe that you need a special version of the ORACLE Server.
>>
>> Multi-threaded server in ORACLE refers to the way connections are made to
>> the database. In the default ORACLE installation all connections are made
>> through dedicated server processes, one process for each ORACLE connection.
>> ORACLE allows you to set up a multi-threaded server configuration which
>> eliminates the need for a dedicated server process for each connection.
>> There are a number of init.ora parameters that need to be set up for MTS.
>> Check you Server Administrator's Guide for more information.
>> 67auh0$s9n_at_camel20.mindspring.com>...
>> >I inquired about configuring Oracle for an SMP server
>> >(multi processor) and was told that a special version
>> >of Oracle Server is required. I'm a bit confused
>> >because I thought SMP processing was a function of
>> >the OS, not the application (assuming the application
>> >was fully threaded). Can anyone confirm this? Does
>> >this mean that Oracle server is not multi-threaded?
>> >
>
>--
>Thanks ..
>=========================
>Pinchas Nisenson
>Data Base Manager
>University (of Calgary) Computing Services
>E-mail: nisenson_at_acs.ucalgary.ca
>Phone: (403) 220-4447
>Fax: (403) 282-9361
Received on Fri Dec 19 1997 - 00:00:00 CST