parallel instances

From: b c via OracleMonster.com <forum_at_OracleMonster.com>
Date: Thu, 27 Jan 2005 21:20:15 GMT
Message-ID: <427f4ab271654cb880210ed156cb6a6b@OracleMonster.com>

1)On a Win2000 with Oracle 8.1.7.4 I have configured two parallel instances originally. Each instance has a service running on it. One service was configured for testing and a second to see wether there is any interference between parallel services. Both services/instances are started automatically at bootup.

The performance has been poor from the moment I started the services and changed it from manually to automatically (default: manually, stopped).

Is it true that parallel instances make an impact on the server performance even though the service is not started?

2) Oracle has the option to configure an typical database mainly for querying (datawarehouse option). How much difference does it performance-wise when choosing this datawarehosue option?

-- 
Message posted via http://www.oraclemonster.com

Received on Thu Jan 27 2005 - 15:20:15 CST