Re: Memory usage

Hi Jan,

It depends (don't you just love it when someone says that).

What you're basically asking is a tuning question. How much memory is required to run my database effectively. The answer might be less than 100M, might be more (might be considerably more).

You (the DBA) can configure Oracle to more or less use as much memory as you wish. How is all in the init.ora parameter file (or spfile, you haven't mentioned DB version). To what is somewhat important in that too much memory is possibly wasteful and leads to tuning issues, too little is obviously no good either. You need to set your memory right. What is right obviously depends on a whole bunch of stuff, no clues of which you've mentioned.

So I would recommend looking at the Oracle doco set at http://tahiti.oracle.com and having a good read of the Concepts manual and the Performance Tuning manual. Being a SQL2000 dude, I would also recommend Thomas Kytes book Expert One on One Oracle.

You will find Oracle is a somewhat different beast to what you may be used to.

Good Luck

Richard
"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 - 09:34:46 CDT