Re: How can I get Oracle to use my new memory?

Stan Brown wrote:

>
> 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.
>

        If you want to use the new memory for database buffers you will have to increase the value for db_block_buffers.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one