Re: MEMORY

I wouldn't recommend to increase the SGA (System Global Area) to more than the pysical memory size. This would result in swapping the SGA to be swapped which decreases the performance significantly.

I normally allow the database to take about up to half the size of the physical memory. The rest can be used by the the operating-system and database processes. If you have a very large amount of memory you might be able to go up to 80 % of memory usage for the SGA.

Regards

Thomas

andrew_webby at hotmail wrote:
>
> 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.
> >
> >
> >
> >
 

-- 


 
_______________________________________________________________________
Siemens Switzerland Ltd, Softwarehaus, ES41
Thomas Jegen, Software Engineer
Albisriederstrasse 245, CH-8047 Zürich
Phone +41 (0)1 495 3438, Fax  +41 (0)1 406 5340 
mailto:thomas.jegen@siemens.ch, Internet: http://www.siemens.ch/