Re: SGA

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Thu, 29 Nov 2007 13:41:49 -0500
Message-ID: <13ku1veb7m3c478@corp.supernews.com>

"noumian" <n.noumia_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 Received on Thu Nov 29 2007 - 12:41:49 CST