Re: When to Create Database vs Schema only !!!
Date: 1996/02/08
Message-ID: <4fc1dh$bvn_at_widow.nla.gov.au>#1/1
>
> When to Create Database vs Schema only !!!
>
...snip ...
>In other words, what reasons drive the need to create a
> separate Database? Reduce load on engine, recovery, resource
availability ??
Isolation is the main reason for needing a separate database.
If you only had one database then both applications would contend for ALL the SGA space.
Pros:
One database can be shutdown, worked on, backed up, whatever, without impacting the other.
Individual databases can be moved to separate machines or, if allowed, restricted by the OS to only certain cpu processors,
All processes for one database could be set to a higher priority than the other database.
You can tune the SGA specifically for that separate database.
Cons:
Extra overhead, more processes, duplicated data dictionary disk space, uses more memory.
Bruce... Received on Thu Feb 08 1996 - 00:00:00 CET