[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference utrop1::linkworks_v3

Title:	LinkWorks V3.0 Notes Conference
Notice:	LNX_APO = APO issues, LINKWORKS_V3 = V3.0 issues
Moderator:	tacklr.apd.dec.com::TACK_Lm::TACK_L

Created:	Tue Jun 28 1994
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	2269
Total number of notes:	8338

2153.0. "one Oracle instance per cell. Why?" by ATYISA::61569::coutant () Wed Mar 05 1997 21:29

    
    Hello!
    
    One of my customers wants to implement LinkWorks Multiple cells on a
    server with Oracle for managing several kinds of internal data.

    Why LNX needs one Oracle instance per cell?
    Which is the technical reason (SQL server seems different)?
    What are the consequences?
    
    If my system needs 128 MB with one cell, how much it requires for 2 cells (number of users and data equal in both cases)?
 
    Thanks in advance.
                         
    Patrice

T.R Title User Personal
Name Date Lines

2153.1 database = instance maandaj.uto.dec.com::~::ANONYMOUS% Tue Mar 11 1997 11:16 9

T.R	Title	User	Personal Name	Date	Lines
2153.1	database = instance	maandaj.uto.dec.com::~::ANONYMOUS%		`Tue Mar 11 1997 11:16`	9
	In Oracle the 'database' is in fact the instance. There is no level between this instance and the tables. Table names have to be unique, so for each cell you need an instance of Oracle. In Ingres, MS-SQL and Informix you can really can create databases with a specific name such as cell1, cell2 etc. so you don't need a new instance for each cell, you just create a new database. Jos

In Oracle the 'database' is in fact the instance. There is no level between
this instance and the tables. Table names have to be unique, so for each cell
you need an instance of Oracle.

In Ingres, MS-SQL and Informix you can really can create databases with a specific
name such as cell1, cell2 etc. so you don't need a new instance for each cell, you just
create a new database.

Jos