Re: Give more memory to Oracle7 server

Depends on where you NEED the memory. The shared_pool_size adjusts the amount of memory in the SGA dedicated to shared resources such as SQL statements, data dictionary entries, etc. However, the most dramatic effect usually has to do with the setting of DB_BLOCK_BUFFERS which holds the blocks of data in a shared area in Oracle. Check out the manuals for properly sizing all the components of the SGA.

John Papadomichelakis wrote:

> Is shared_pool_size the key to give more memory to Oracle on an HPUX
> system?
>
> Which size would give the best results on an 128Mb system?
>
> --
>
> "Unite for Java! - http://www.javalobby.org"
> __________________________________________________
> email : michelos_at_freemail.gr
> TEL : 30 31 758 429, 30 31 709 796
> __________________________________________________
>
> ------------------------------------------------------------------------
>
> John Papadomichelakis <michelos_at_freemail.gr>
> C/S Developer
> Logismos S.A.
>
> John Papadomichelakis
> C/S Developer <michelos_at_freemail.gr>
> Logismos S.A. HTML Mail
> 9 Filippou Netscape Conference Address
> Euosmos Netscape Conference DLS Server
> Thessaloniki
> 56 224
> Greece
> Additional Information:
> Last Name Papadomichelakis
> First NameJohn
> Version 2.1
Received on Fri Jan 02 1998 - 00:00:00 CST