Re: MEMORY

Well, one of mine is 8.1.6 with 36gb - and it is sized like this:

db_block_buffers: 12200 (95mb)
shared_pool_size: 175000000

Total (roughly) SGA: 270mb

I have 4gb machine (with 5 other databases, but this is the largest production LIVE database).

See what I mean? I could go mad and throw another couple of hundred meg into the fire, but the performance isn't going to be much greater. (Yes, I am aware that a lot of the memory might appear wasted in this case... but there are considerations I don't want to get too into here..)

"mr" <morten_at_hwt.dk> wrote in message
news:Xx9N6.110$kL.8558_at_news.get2net.dk...
> well it's an 8.04 with dbsize of 4GB!
>
>
>
> "Joe Maloney" <mpir_at_bellsouth.net> skrev i en meddelelse
> news:d17bad25.0105180528.407bfeab_at_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 - 09:16:09 CDT