Re: Memory vs Database

Are you sure this is memory?

On HPUX it could be the way your unix kernel is set up.

Make sure you have the recommended ( ideally higher) settings in your kernel for:

Maximum shared memory segment size ( SHMMAX) maximum number of shared memory segments (SHMMNI) Maximum number & size of semaphores ( SEMMNI etc)

I remember from my HP days these were always set in the HP kernel far too low to support Oracle.

If you're getting an error with the words "No Space left on device" in it ( I can't unfortunately remember the exact wording) then the above is certainly your problem. You'll need to re-configure your HP kernel and reboot.

Another possibility you might try is if you have the PRE_PAGE_SGA parameter set on your first database - try turning this off if you're desperate. Beware that there will be a performance hit on both databases if you do this.

BC

Brian Cadwell
Sharp Point Consultants

Anders Henriksson <anders.henriksson_at_mail.bip.net> wrote in article <01bd9565$ce04d2a0$5b62dcc1_at_ah.trx.sema.se>...
> Hello!
>
> I'm trying to create another database (7.3.3) on my machine (HP-UNIX with
> 64MB)
> The first database is a small database just for testing purpose. When I
try
> to startup the second database I can't because of insufficient memory.
> I've tried to set the lowest values for the parameters in the init.ora
file
> - but
> the database won't come up.
>
> How come? Does anybody got a formula to calculate memory requirements ?
>
> Regards
> /anders
>
>
Received on Thu Jun 11 1998 - 18:22:14 CDT