Re: Memory usage

Jan,

Are you using this for personal usage? I suspect this is the case when you have a system with only 256 MB, but some Window boxes are small.

Oracle take so much because of the direction the programmers took in using buffers to hold the database data. In a production/active database, the best place for frequently used data is in memory. Hence, this direction by the programmers. I just rolled off a contract client had 2 AIX machines each with 10 GB of RAM (the production instance on one box; the other box having test and development instances). The only application running on these boxes was the Oracle database.

This direction while good for production/highly active systems is NOT good for lightly used personal systems. This is the reason for my first question.

So to be honest, to tell you how to optimize your RAM really requires understanding the purpose of the base, whatelse is on the machine, and knowing the release.

I run 9.2.0.1 (Oracle 9i Release 2) and use it for keeping track of personal and professional stuff. My system is a Dell laptop at 512 MB and I run Oracle normally at 94 MB (VMSize = 128 MB). I find 9i takes more RAM than 8i, BTW.

Bertram Moshier
Oracle Certified Professional 8i DBA

http://www.bmoshier.net/bertram

"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 Wed Oct 30 2002 - 22:16:54 CET