Re: Database(s) per instance ?

On Mon, 3 Apr 1995, Carl Gohringer wrote:

> tgillesp_at_ms13.mis.semi.harris.com (Tom Gillespie) writes:
> : Can anyone site any advantages to having more than one database per ORACLE
> : instance, other than saving shared memory (SGA) ?
> : --snip--
>
> A moot question. It is not possible to have more than one database per
> instance.
> --
> regards,
> Carl
> +-----------------------------------------------------------------------------+
> Carl Gohringer, Oracle European Development Centre, World Wide Education

        No it isn't a 'moot question' !         

	I believe he means tables from multiple applications.  
	They could, for instance be segregated by owner (aka schema) 
	and/or tablespace.

	An advantage -could- be a single TEMPORARY tablespace, 
	instead of a separate one in each instance.  Also, if
	people tend to use more than 1 application, they would
	have to keep changing SIDs to go from 1 to the other.
	Having one instance could be more convenient.

	However, I agree that 'single point of failure' disadvantage 
	probably outweighs most advantages to collecting everything 
	together.

	Unless memory and/or storage are a -serious- problem.

	helena

--
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>
<: Helena Whitaker, Database Administrator      helena_at_creighton.edu :>
<: Creighton University               (0800-1630 CT)   (402)280-2311 :>
<: Old Gym - 2500 California Plaza                fax  (402)280-2573 :>
<: Admin Computing-Fin Sys Spt          Platform: HP-UX 9.0.4 (unix) :>
<: Omaha, NE 68178-0046              HP 9000/887 (aka H50), 842, 806 :>
<:                            Oracle 6.0.36.7.1/Banner Finance 2.0.3 :>
<:                            Oracle 7.1.3/DeLair Patient Accounting :>
<:>-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<->-<:>