Re: SGA size

As a quick overview, the SGA is made up of serveral parts, the database buffers, redo log buffers, and shared pool.... these 'parts' each have parameters in the init.ora. Probably the most crucial one is db_block_buffers, the others are shared_pool_size, and log_buffer. Remember that db_block_buffers parameter is multiplied by the db_block_size when calculating the size of the SGA...

Cheers,

Robert Prendin
Bertalan GOMBOS <gombos_at_finit.hu> wrote:

>Hi all!
>
> How can I set the size of SGA? I haven't found any parameter in
>INIT.ORA which set the SGA size.
>
> Thanks, bye:
> Bert
>--
> :
> ----.----, ------------------------------:----------------------------
> --;----"-----, ,--------, ,--------, | Bertalan Gombos
> | | ;--------' | | software engineer
> ---|----------' `-------- | | bgombos_at_freemail.c3.hu
>`----' --------------------------------- `------------------------ '98

#****************************************************
#	RP Data Solutions Inc.
#	Specializing in ORACLE DBA Support Services
#       We offer 24HR remote DBA support!!!
#****************************************************