Re: Memory usage

I do know what init.ora is. I am no numskull! I have years of experience with databases: Progress, Sybase, SqlServer. Except Oracle...
But I can read manuals and I do understand the answers of experienced oracle users.
So if you tell me which parameters in init.ora affects memory usage I am very well able to read about it in the helpfiles and do some memory tuning myself.

"Steve M" <steve.mcdaniels_at_vuinteractive.com> wrote in message news:ap9stu$l44$1_at_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 Fri Oct 25 2002 - 09:14:23 CEST