Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h78FRn031601 for ; Fri, 8 Aug 2003 10:27:49 -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 h78FRmp31593 for ; Fri, 8 Aug 2003 10:27:48 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h78CutN09678 for oracle-l@orafaq.net; Fri, 8 Aug 2003 05:56:55 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005C9A3D; Fri, 08 Aug 2003 05:49:23 -0800 Message-ID: Date: Fri, 08 Aug 2003 05:49:23 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Loughmiller, Greg" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Loughmiller, Greg" 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_001_01C35DAB.E3985D30" ------_=_NextPart_001_01C35DAB.E3985D30 Content-Type: text/plain; charset="iso-8859-1" we throw'm on there until we hit a predetermined capacity mark.. If it's a 100, cool.. Or if it's 20.. Just depends on the app, volume of txn's and memory requirements.... The caveats that are considered are some of the necessary kernal parms (semaphores, shared memory,etc).. Load it up, watch the capacity of the server.. And push the envelope:-) Greg -----Original Message----- Sent: Friday, August 08, 2003 8:20 AM To: Multiple recipients of list ORACLE-L We have about 35 instances on each node of RAC they are of course DEVL/ACPT types. Raj ---------------------------------------------------------------------------- ---- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -----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? 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 ----- To: Multiple recipients of list ORACLE-L 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 ----- To: "Multiple recipients of list ORACLE-L" < ORACLE-L@fatcity.com > 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: 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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_001_01C35DAB.E3985D30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
we throw'm on there until we hit = a=20 predetermined capacity mark.. If it's a 100, cool.. Or if it's 20.. = Just depends=20 on the app, volume of txn's and memory requirements....
 
 
The caveats that are considered = are some of=20 the necessary kernal parms (semaphores, shared memory,etc).. Load it = up, watch=20 the capacity of the server.. And push the envelope:-)
 
Greg
 
 
-----Original=20 Message-----
From: Jamadagni, Rajendra=20 [mailto:Rajendra.Jamadagni@espn.com]
Sent: Friday, August = 08, 2003=20 8:20 AM
To: Multiple recipients of list = ORACLE-L
Subject:=20 RE: 100 instances on same server !!!

We=20 have about 35 instances on each node of RAC they are of course = DEVL/ACPT=20 types.
 
Raj
-------------------------------------------------------------------= -------------=20
Rajendra dot Jamadagni at nospamespn = dot=20 com
All Views expressed in this = email are=20 strictly personal.
QOTD: Any = clod can have=20 facts, having an opinion is an art !
-----Original 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=20 on 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=20 ORACLE-L
Sent: Thursday, August 07, = 2003 11:54=20 AM
Subject: Re: What books = recommended=20 for Data Modeling ?

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

-ak



----- Original Message ----- =
To:=20 "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sen= t:=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=20 re-installing databases on 100 workstations after each = round
of
>=20 > training.
> > - No user should see any other user's = data.
> >
> > Please suggest if this approach = is=20 feasible or is it at all possible.
Tested this with upto 5 = instances,=20 and
> > it seems to work. The customer is willing to = upgrade to=20 any hardware
needed for
> > this setup.
> = >
>=20 > Thanks in advance for your time.
> >
> >=20 Dilip.
> >
>
> --
> Please see the = official=20 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=20 Diego, California        -- = Mailing=20 list and web 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= =20 City Network Services    -- 858-538-5051 http://www.fatcity.com
San = Diego,=20 California        -- Mailing = list and=20 web 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=20 information (like=20 subscribing).
------_=_NextPart_001_01C35DAB.E3985D30-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Loughmiller, Greg INET: Greg.Loughmiller@cingular.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).