Using Multiple Databases
Date: 9 Mar 1994 11:39:28 -0600
Message-ID: <2ll1kg$2d7_at_tisdec.tis.tandy.com>
We are currently running a Oracle V6 under a DEC/Ultrix environment supporting two seperate application systems. In recent months, there has been talk of adding another application system (with 3 - 4 subsystems) to our database.
Optimally, what we would like to do is to create a seperate database for the new system and its required subsystems, but that has never been done at our site. I am presently researching information about running multiple databases and what kinds of things have happened to those of you that have done this.
Our applications are running a DEC 5900 and are written exclusively in in SQL*Forms 3.0, SQL*ReportWriter 1.1, SQL*Menu 5.0, and we are using Pro*C 1.1 to interface 'C' language programs with the current Oracle Database.
The system for which this research is being done is written in Ryan-MacFarlane COBOL and will be using RM+DB to access the database.
I have some basic questions about the merits/demerits of doing this:
- How much overhead are we talking about in having two databases?
- What type of performance cut (ballpark estimates are fine)
will the system take from two databases?
- What are the effects on the existing programs that are already
connecting to the existing database using '/' and not specifying an "AT" in the "CONNECT"?- What will be the effects on the Oracle Tools (SQL*Forms, etc.)?
- Would a single program, form, etc. be able to access both
databases at the same time?- What other effects (positive or negative) might this have?
Thank you in advance for your attention and help in this matter.
Byron Pearce | The thoughts and views herein do not Tandy Information Services | necessarily reflect that of Tandy bpearc1_at_tisdec.tis.tandy.com | Corporation. ------------------------------------------------------------------------------"The Ten Commandments are not multiple choice." - Anonymous
Received on Wed Mar 09 1994 - 18:39:28 CET