How can I get Oracle to use my new memory?

From: Stan Brown <stanb_at_panix.com>
Date: 25 May 2001 09:07:26 -0400
Message-ID: <9ellee$ln$1@panix2.panix.com>

I jsut upgraded my HP 9000/785 runing B.10.20 C on which I am runing Oracle 7.3.4.5 from 256MB to 758MB . I did this in order to allow Oracel to use more memory for database buffers,

However I am having a bit of a problem geting Oralce to use this new memory. I have the following paramaters set in my Oracle init file, at the moment:

db_block_buffers = 12800 
db_file_multiblock_read_count = 64 
db_block_buffers = 12800 

shared_pool_size = 425000000

Originaly I had shared_pool_size = 9000000. My problem is that if I increase the shared_pool_size to be much larger than this I get the following error on Oracle startup:

SVRMGR> ORA-07306: sms1sg: shmget error, unable to get a shared memory segment.
HP-UX Error: 12: Not enough space
Additional information: 1

So it seems that the problem is with allocationg a shared memory segment.

Without the Oracle instance running Glance rports:

Total VM : 69.6mb Sys Mem : 78.7mb User Mem: 172.9mb Phys Mem: 768.0mb
Active VM: 44.7mb Buf Cache: 76.8mb Free Mem: 439.5mb

With the instance runing, and the above tuning paramaters, it reports:

Total VM : 55.7mb Sys Mem : 78.7mb User Mem: 115.4mb Phys Mem: 768.0mb
Active VM: 37.2mb Buf Cache: 65.2mb Free Mem: 508.6mb

As far as kernel paramters, I have:

shmmax set to 0X40000000
shmmni set to 512
shmseg set to 120

Can anyone sugest what I need to do to get Oracle to use more of this extra memory?

Thanks. Received on Fri May 25 2001 - 08:07:26 CDT