Re: What books recommended for Data Modeling ?

I have not heard installing hundred database instances on same server. Maybe you should think creating one instance, and then hundred schemas in it.

Guang

On Wed, 6 Aug 2003, Dilip Patel wrote:

> Hi All,
> Need some suggestions/Input.
>
> My application database is 8.1.7, NOARCHIVELOG, WIN200,
> total size 4 GB, more of single user OLTP client-server application.
>
> Now the customer wants to give training on this application to hundred trainees
> at a time. For this he wants to install hundred database instances on same
> server machine, which *each* will be accessed simultaneously from 100 different
> client workstations.
>
> The reasons for installing all instances on same machine are
> - to avoid re-installing databases on 100 workstations after each round of
> training.
> - No user should see any other user's data.
>
> Please suggest if this approach is feasible or is it at all possible. Tested this with upto 5 instances, and
> it seems to work. The customer is willing to upgrade to any hardware needed for
> this setup.
>
> Thanks in advance for your time.
>
> Dilip.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).