|
Now , what is your server configuration ? windows , sun ,
hp ?? memory ??
-ak
----- Original Message -----
Sent: Thursday, August 07, 2003 3:54
PM
Subject: Re: 100 instances on same server
!!!
Thanks for the replies so far. Considering the fact that my database is
tiny ( just around 3 GB ), How many of them can work on same server? I can
just test with 5 instances, with limited hardware. Will the CPUs be able to
take load of 100 instances? Is it worth experimenting this?
I am on 8.1.7.4 and the application is already built. I stand no chance
of changing the code. That is why using individual schemas for individual
users is not an option. Right now I am just asked if 100 instances can run on
same server and I don�t have solid answer.
Just on side note, can I ask, What is the maximum number of
instances anyone has ever worked/heard being installed with in same
server?
Thanks again.
Dilip.
----- Original Message -----
Sent: Thursday, August 07, 2003 11:54
AM
Subject: Re: What books recommended for
Data Modeling ?
100 instances wohhhhh . If you are in 9i look at
possibilities like context
or label security . or creating another schema
.
-ak
----- Original Message -----
To: "Multiple
recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent:
Wednesday, August 06, 2003 9:24 PM
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>
--
Please see the
official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
AK
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
|
