Re: Create DB and error 07331

Try reducing the size of your db_block_buffers. This one will significantly reduce the size of your SGA. Performance will stink, but it will fit in your system. If you only have 48M of entire memory, then it it likely this is your problem. There are several paramters that limit the size of the SGA on the kernel size. The parameter SHMMAX is one, so is SHMSEG. Your system administrator will know how to change them, but it will require a reboot of your system, PLUS you don't want to kill the entire operating system by taking all the available memory. To determine how many db_block_buffers you currently have take the block size of your database. (If you didn't change it in your init.ora or config.ora file - it is probably 4k) and multiply db_block_buffers by your block size. This will give you the number of bytes currently allocated for that parameter. Also, look at the Shared_pool_size - this is in the form of bytes

-Sheilah Scheurich
DBA
My email is wrong - remove the words "want no spam at all" to send me anything.

Brian Motzer wrote:

> I've recently installed an Oracle version 7.3.3 database on a sparc LX
> workstation with 48 megs
> of ram. When trying to run a create database command I get the following
> error:
>
> ORA-07331 smsnsg: unable to allocate the variable portion of the sga
> additional information: 4
>
> I've tried reducing the number of processes in the init.ora and a couple
> of other things. Is this crazy to think that
> I'm going to get Oracle running on a unix platform with so little
> memory? The error manual suggests reconfiguring
> the kernal to get a bigger segment size, is this even possible?
>
> Thanks,
> please email to bmotzer_at_spacestar.com
Received on Tue Jan 13 1998 - 00:00:00 CST