Re: sga and shared pool size

In article: <3i2ul6$gqt_at_lucy.infi.net> gtravis_at_richmond.infi.net (Glenn Travis) 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?
>
> I have noticed that the same number entered for shared_pool_size produces
> different output form the show sga command on different machines. Any
> insight would be much appreciated.
>
> Thanks.
> --
> Glenn Travis
> DBA
> Circuit City Stores, Inc.
> Richmond, VA USA
> gtravis_at_richmond.infi.net
> gtravis_at_aol.com
>
>
>

-- 

	There is more than one parameter which govens the total size of the 
sga.

	The major ones are as follows.

	db_block_buffers  	: this determines the number of database	
				buffers available for in memory block
				caching

	db_block_size		:  the size of each block.

	shared_pool_size	: the amount of memory you wish to reserve for
				caching of sql statements, procedures and pl/sql
				blocks.

	log_buffer		:  the size of the redo log buffer 

	sizing these correctly is critical for the performance of your system.

---

	Tim L