Re: SGA

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, 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 - 12:59:29 CST