Re: sga and shared pool size

From: Javier Seen <jseen_at_us.oracle.com>
Date: 18 Feb 1995 20:53:09 GMT
Message-ID: <3i5mnl$9bh_at_dcsun4.us.oracle.com>


In article <3i2ul6$gqt_at_lucy.infi.net> gtravis_at_richmond.infi.net writes:
>As the subject suggests, I would like to know the correlation between the
>parameter 'shared_pool_size' in the init.ora file - to the output from
>the 'show sga' command in sqldba. Basically, if I want to giv ethe
>oracle server 35 MB of memory, how do I do that? Where is this number
>entered in the init file? or is it?

SGA is the System Global Area, which encompasses all components of the ORACLE memory structures, which includes the shared pool. Basically, the size of the SGA is computed based on all the init.ora parameter values that pertain to structures in the SGA, such as db_block_buffers, log_buffer, shared_pool_size, etc.

Obviously, increasing shared_pool_size changes the final SGA size accordingly. The shared pool is just (as the name implies) a pool of memory to be allocated by the server on behalf of a client, e.g. compiled stored objects, client's PGA (if running MTS), etc.

For more information, check the Concepts Manual (and the DBA Guide as complement). Look in the index for sections discussing these memory structures.

Hope it helps,

--js Received on Sat Feb 18 1995 - 21:53:09 CET

Original text of this message