Re: Effect of lack of memory

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 10 Jan 2003 06:44:38 +0100
Message-ID: <icns1vgh2r7dudlmrmq7adm8l54ebg22mi@4ax.com>

On Fri, 10 Jan 2003 00:04:29 +0100, Rick Denoire <100.17706_at_germanynet.de> wrote:

>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

You shouldn't have tuned the ;production database to the amount of available RAM in the first place, the Oracle guidelines are quite clear about that.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 09 2003 - 23:44:38 CST