Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h78NQPL28520 for ; Fri, 8 Aug 2003 18:26:25 -0500 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h78NQOp28515 for ; Fri, 8 Aug 2003 18:26:24 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h78L2ej07821 for oracle-l@orafaq.net; Fri, 8 Aug 2003 14:02:40 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005C9AF7; Fri, 08 Aug 2003 13:54:30 -0800 Message-ID: Date: Fri, 08 Aug 2003 13:54:30 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Ron Yount" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Ron Yount" Subject: RE: 100 instances on same server !!! Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_01BE_01C35DC5.C0CFCC10" ------=_NextPart_000_01BE_01C35DC5.C0CFCC10 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable We have 60 instances on one development box, but that cannot be compared = to production servers. I am not sure I understand the base question. If = you have adequate memory and cpu, I don't think there is a known limit on instances. Of course, there are several resource issues that come into = play beyond cpu and memory such as the max processes for the server itself, = the number of spindles required to support 100 independent instances.... =20 -Ron- -----Original Message----- Adams, Matthew (GECP, MABG, 088130) Sent: Friday, August 08, 2003 6:19 AM To: Multiple recipients of list ORACLE-L Right now I have 37 instances on an hp-ux server, a mix of 8.1.7.4 and 9.2.0.3 =20 ---- Matt Adams - GE Appliances - matt.adams@appl.ge.com We are pentium of Intel. Division is futile. You will be approximated.=20 =20 -----Original Message----- Sent: Thursday, August 07, 2003 6:54 PM To: Multiple recipients of list ORACLE-L 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?=20 =20 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.=20 =20 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?=20 =20 Thanks again. =20 Dilip. ----- Original Message -----=20 To: Multiple recipients of list ORACLE-L =20 Sent: Thursday, August 07, 2003 11:54 AM 100 instances wohhhhh . If you are in 9i look at possibilities like = context or label security . or creating another schema . -ak ----- Original Message -----=20 To: "Multiple recipients of list ORACLE-L" 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. > > > > --=20 > Please see the official ORACLE-L FAQ: http://www.orafaq.net > --=20 > Author: Guang Mei > INET: gmei@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@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). > --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author: AK INET: oramagic@hotmail.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@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). ------=_NextPart_000_01BE_01C35DC5.C0CFCC10 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
We have 60 instances on one = development box,=20 but that cannot be compared to production servers.  I am not sure I = understand the base question.  If you have adequate memory and cpu, = I don't=20 think there is a known limit on instances.  Of course, there are = several=20 resource issues that come into play beyond cpu and memory such as the = max=20 processes for the server itself, the number of spindles required to = support 100=20 independent instances....
 
-Ron-
-----Original Message-----
From: = ml-errors@fatcity.com=20 [mailto:ml-errors@fatcity.com] On Behalf Of Adams, Matthew = (GECP, MABG,=20 088130)
Sent: Friday, August 08, 2003 6:19 AM
To: = Multiple=20 recipients of list ORACLE-L
Subject: RE: 100 instances on = same=20 server !!!

Right now I have 37 instances on = an hp-ux=20 server,
a mix of 8.1.7.4 and = 9.2.0.3
 

----
Matt Adams - GE Appliances - matt.adams@appl.ge.com
We = are=20 pentium of Intel. Division is futile.
You will be approximated. =

 
-----Original=20 Message-----
From: Dilip Patel=20 [mailto:patel_dil@msn.com]
Sent: Thursday, August 07, 2003 = 6:54=20 PM
To: Multiple recipients of list = ORACLE-L
Subject: Re:=20 100 instances on same server !!!

Thanks for the replies so far. Considering the fact that my = database is=20 tiny ( just around 3 GB ), How many of them can work on same server? I = can=20 just test with 5 instances, with limited hardware. Will the CPUs be = able to=20 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=20 of changing the code. That is why using individual schemas for = individual=20 users is not an option. Right now I am just asked if 100 instances can = run on=20 same server and I don’t have solid answer.
 
Just on side note, can I ask, What is the maximum number of=20 instances anyone has ever worked/heard being installed with in = same=20 server?
 
Thanks again.
 
Dilip.
----- Original Message -----
From: AK
To: Multiple recipients of list = ORACLE-L=20
Sent: Thursday, August 07, = 2003 11:54=20 AM
Subject: Re: What books = recommended for=20 Data Modeling ?

100 instances wohhhhh .  If you are in 9i look = at=20 possibilities like context
or label security . or creating = another schema=20 .

-ak



----- Original Message -----
To: = "Multiple=20 recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sent= :=20 Wednesday, August 06, 2003 9:24 PM


> I have not heard=20 installing hundred database instances on same server.
> Maybe = you=20 should think creating one instance, and then hundred schemas = in
>=20 it.
>
> Guang
>
> On Wed, 6 Aug 2003, Dilip = Patel=20 wrote:
>
> > Hi All,
> > Need some=20 suggestions/Input.
> >
> > My application database = is=20 8.1.7, NOARCHIVELOG, WIN200,
> > total size 4 GB, more of = single=20 user OLTP client-server application.
> >
> > Now = the=20 customer wants to give training on this application to=20 hundred
trainees
> > at a time. For this he wants to = install=20 hundred database instances on
same
> > server = machine, =20 which *each* will be accessed simultaneously from = 100
different
>=20 > client workstations.
> >
> > The reasons for=20 installing all instances on same machine are
> > - to avoid = re-installing databases on 100 workstations after each = round
of
>=20 > training.
> > - No user should see any other user's=20 data.
> >
> > Please suggest if this approach is = feasible=20 or is it at all possible.
Tested this with upto 5 instances, = and
>=20 > it seems to work. The customer is willing to upgrade to any=20 hardware
needed for
> > this setup.
> >
> = >=20 Thanks in advance for your time.
> >
> > = Dilip.
>=20 >
>
> --
> Please see the official ORACLE-L = FAQ: http://www.orafaq.net
> -- =
>=20 Author: Guang Mei
>   INET: gmei@incyte.com
>
> = Fat City=20 Network Services    -- 858-538-5051 http://www.fatcity.com
> = San Diego,=20 California        -- Mailing list = and web=20 hosting services
>=20 = ---------------------------------------------------------------------
= >=20 To REMOVE yourself from this mailing list, send an E-Mail = message
>=20 to: ListGuru@fatcity.com = (note=20 EXACT spelling of 'ListGuru') and in
> the message BODY, = include a=20 line containing: UNSUB ORACLE-L
> (or the name of mailing list = you=20 want to be removed from).  You may
> also send the HELP = command=20 for other information (like subscribing).
>
--
Please = see the=20 official ORACLE-L FAQ: http://www.orafaq.net
-- =
Author:=20 AK
  INET: oramagic@hotmail.com

Fat = City=20 Network Services    -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California        -- Mailing list = and web=20 hosting=20 = services
-------------------------------------------------------------= --------
To=20 REMOVE yourself from this mailing list, send an E-Mail = message
to: ListGuru@fatcity.com (note = EXACT=20 spelling of 'ListGuru') and in
the message BODY, include a line=20 containing: UNSUB ORACLE-L
(or the name of mailing list you want = to be=20 removed from).  You may
also send the HELP command for other = information (like=20 subscribing).
------=_NextPart_000_01BE_01C35DC5.C0CFCC10-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Yount INET: ronwy@swbell.net 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@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).