Re: Need information on Oracle Performance
Date: 1995/07/17
Message-ID: <806021266.23412_at_toronto.demon.co.uk>#1/1
asham_at_bnr.ca wrote:
snipped...
> Also,
> Is it true that Oracle servers start a new process per user session?
Normally, yes. But the V7 Multi-Threaded Server sets up a number of
dispatchers, each of which can handle a number of users.
> and if so, how does it scale up as the number of user sessions increases?
> How many con-current sessions can it support simultaneously?
Depends on memory size. No fixed limit as far as I know.
If using MTS, each dispatcher can only handle a small number of concurrent users, but Oracle can be set up to dynamically create dispatchers up to any maximum.
> What are the options for moving an Oracle database from a single to a
> multi-processor environment?
>
Would've thought it was much the same as moving from one physical machine to another. Set up a parallel Server & Import the data.
> Regards,
> Asham El Rayess
>
>
Received on Mon Jul 17 1995 - 00:00:00 CEST