Re: Effect of lack of memory

From: David Sharples <david.sharples3_at_ntlworld.com>
Date: Thu, 9 Jan 2003 23:12:22 -0000
Message-ID: <plnT9.3632$rJ.22206@newsfep4-win.server.ntli.net>

one or the other might not stop up with EOF on communication channel, if kernel paramters are not set high enough

as for memory, you will start swapping, bad for performance on your production db

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:edvr1vcvg1uracc0c04ld1i0b5r7rmh7lm_at_4ax.com...
> Hello
>
> I run a production database (Oracle 8.1.7 on Sun E3500) which is tuned
> to the amount of available RAM (2GB). For a short time and only for
> test purposes, I would like to setup a clone of this DB (under a
> different name of course) and am wondering what happens when I fire up
> this second DB and the demand of memory of both instances will go
> beyond available physical memory.
>
> Will the start of the clone DB fail? Will the production DB
> crash/hang?
>
> I just want to avoid shutting down the production DB since it is
> needed around the clock.
>
> Thanks in advance
> Rick Denoire
Received on Thu Jan 09 2003 - 17:12:22 CST