Re: MEMORY

From: Joe Maloney <mpir_at_bellsouth.net>
Date: 18 May 2001 06:28:13 -0700
Message-ID: <d17bad25.0105180528.407bfeab@posting.google.com>

You did not say what version of Oracle you are using, but if you are considering upgrading to O9i when it is released next week (or as a prep/comparison), you might take a look at the self tuning features.

Depending on your apps, 300MB may be enough or even a lot.

"andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message news:<990182104.22974.0.nnrp-07.c30bdde2_at_news.demon.co.uk>...
> and READING THE MANUAL.
>
> Stabbing away at the parameters without knowing a bit more about it will
> bring you nothing but trouble. A pertinent question might be "do you need to
> use more memory" for example...
>
> "rob" <rob_at_dsdelft.nl> wrote in message news:9e2l3d$1j7$1_at_news.tudelft.nl...
> >
> > > how do i get oracle to use more of the main memory (2GB) it uses about
300MB
> > > now
> > By changing the init<sid>.ora parameters for the instance.
> > db_block_buffers
> > shared_pool_size
> > and restarting the instance.
> >
> >
> >
> >
Received on Fri May 18 2001 - 08:28:13 CDT