Re: Memory usage

From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Thu, 24 Oct 2002 15:41:16 -0700
Message-ID: <ap9stu$l44$1@spiney.sierra.com>

your db is performing much more slowly using a swap file than if you downsized the memory
allocated to oracle (so as to prevent it from swapping).

Adjust your INIT<sid>.ORA file parameters. (if you don't know what this is, don't touch it, get someone who does)

"Jan van Veldhuizen" <jvv_at_ontarget.nl> wrote in message news:ap8tu1$gq3$1_at_news1.xs4all.nl...
> Is it really necessary that the Oracle Service takes so much memory?
> If I start the service my memory usage is going up to 350Mb of memory.
> And I have only 256Mb, so there is a lot Swapfile usage.
> Looking at my processes I see that oracle.exe uses almost 100Mb and
jrew.exe
> 18Mb.
> Is there any way to optimize that?
>
> The difference: A running Sql2000 database uses less than 10Mb...
>
> Jan van Veldhuizen
>
>
>
Received on Thu Oct 24 2002 - 17:41:16 CDT