Re: SGA

"Charles Hooper" <hooperc2000_at_yahoo.com> wrote in message news:3768e79f-43e1-46bb-8641-c8b41857a832_at_j20g2000hsi.googlegroups.com...
> On Nov 29, 1:41 pm, "Syltrem" <syltremz..._at_videotron.ca> wrote:
>> "noumian" <n.nou..._at_gmail.com> wrote in message
>>
>> news:661ba94d-4022-47a9-b91b-2d2b2220278f_at_e23g2000prf.googlegroups.com...
>>
>> >i think that my problem is here
>> > Cannot set sga_target with db_block_buffers set
>> > so where and which value can i set to db_block_buffers ?
>>
>> Don't set it. Just remove it from the spfile (you will have to create
>> pfile
>> from spfile, remove the line from the pfile in a text editor, and create
>> spfile from pfile, then startup).
>>
>> Or else set sga_target to 0, it's your choice.
>>
>> In any case you have some more config to do but that will get you
>> working.
>> Read on automatic memory management
>>
>> Syltrem
>> Oracle 10.2 on OpenVMS
>
> To the OP: Maybe it is a problem with specifying both DB_BLOCK_BUFFERS
> and SGA_TARGET - DB_CACHE_SIZE should be used rather than
> DB_BLOCK_BUFFERS,
Exactly, not maybe :-)
But you can make the choice of setting sga_target to zero and change the settings later, or change everything now

db_block_buffers = 0 and db_cache_size > 0 large_pool_size >= 0
shared_pool_size >= 0
java_pool_size >= 0
sga_target > 0 and at least = to sum of all above sga_max_size >= sga_target

or

db_block_buffers > 0 *OR* nd db_cache_size > 0 large_pool_size > 0
shared_pool_size > 0
java_pool_size > 0
sga_target = 0
sga_max_size >= sum of all of the above

Syltrem

> as the error quoted by Syltrem seems to imply.
>
> Brief explanation of the parameters:
> DB_BLOCK_BUFFERS - Specifies the number of database buffers in the
> buffer cache. It is one of several parameters that contribute to the
> total memory requirements of the SGA of an instance. This parameter
> multiplied by the DB_BLOCK_SIZE determines the total size of the
> buffer cache. DB_BLOCK_BUFFERS cannot be combined with the dynamic
> DB_CACHE_SIZE parameter; combining these parameters in the same
> parameter file will produce an error.
>
> DB_CACHE_SIZE - Determines the default cache for the database's
> standard block size, size is specified in bytes. The value must be at
> least 4M * number of cpus * granule size (smaller values are
> automatically rounded up to this value). A user-specified value larger
> than this is rounded up to the nearest granule size. A value of 0 is
> illegal. If SGA_TARGET is specified, this parameter indicates the
> minimum amount of memory to be used for the default buffer pool.
>
> Once again, it would be helpful to see the parameter file used to
> start the server.
>
> Charles Hooper
> IT Mananger/Oracle DBA
> K&M Machine-Fabricating, Inc.
Received on Thu Nov 29 2007 - 13:53:52 CST