Re: Multiple Instances, or one big one...
Date: Wed, 1 Mar 1995 10:31:36 -0800
Message-ID: <Pine.SUN.3.91.950301102118.24083B-100000_at_seatimes>
On 28 Feb 1995 stroup_at_grove.ops.lmsc.lockheed.com wrote:
> Currently we have two Oracle Instances, one for development and one for
> production (and ocasionally we'll add a test instance when we're doing
> kernel upgrades).
I follow the same pattern. In fact, we call the instances PRD, TST, and DEV.
PRD is, naturally, for the production database and has the most secure environment.
TST is supposed to be a known copy of PRD that the users can test the next release or run parrallel for acceptance.
DEV is pretty open for the developors to do their thing. Eventually their stuff is implemented in TST for user acceptance before going to PRD.
You want enough main memory to keep all three SGA in memory. Otherwise, there is a performance penalty for swapping (and all the effort in Oracle to keep the LRU blocks in memory just goes down the drain).
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-464-2905 | | PO Box 70 Internet: sbut-is_at_seatimes.com || Seattle, WA 98111 Packet: Not currently active |
+----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Wed Mar 01 1995 - 19:31:36 CET