Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 100 instances on same server !!!

RE: 100 instances on same server !!!

From: Ron Yount <ronwy_at_swbell.net>
Date: Fri, 08 Aug 2003 13:54:30 -0800
Message-ID: <F001.005C9AF7.20030808135430@fatcity.com>


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....  

-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  



Matt Adams - GE Appliances - matt.adams_at_appl.ge.com We are pentium of Intel. Division is futile. You will be approximated.  

-----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.

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

-ak

> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: oramagic_at_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_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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Yount
  INET: ronwy_at_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_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).
Received on Fri Aug 08 2003 - 16:54:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US