HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
cancel
Showing results for 
Search instead for 
Did you mean: 

Memory use in 11.11

 
Carme Torca
Super Advisor

Memory use in 11.11

Hi,

I have one oracle bbdd, thant when arrives at 2048m of memory use its stops its aplication. I have revised the ulimit

uid=107(oracle) gid=105(dba)

>ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 4292870144
stack(kbytes) 262144
memory(kbytes) unlimited
coredump(blocks) 4194303


The server has got 4Gb memory. Does anyone could help me to known what parameter could I have to increase?

Thanks a lot of,
Carmen.

Users are not too bad ;-)
3 REPLIES

Re: Memory use in 11.11

>that when arrives at 2048m of memory use its stops its application.

How are you measuring it, top(1)?

>I have revised the ulimit

What does kmtune(1m) show for maxdsiz and maxdsiz_64bit?

>Does anyone could help me to known what parameter could I have to increase?

Is this a 32 or 64 bit application? If the former, what does "chatr bbdd" show?
Carme Torca
Super Advisor

Re: Memory use in 11.11


How are you measuring it, top(1)?
Database Administration is measuring it.


What does kmtune(1m) show for maxdsiz and maxdsiz_64bit?

# kmtune | grep -i maxdsiz
maxdsiz 2147483648 - 2147483648
maxdsiz_64bit 0x80000000 - 0X80000000

Is this a 32 or 64 bit application? If the former, what does "chatr bbdd" show?

Is a 64 bit application. The aplication is an oracle database.

Thanks a lot of,
Carmen.
Users are not too bad ;-)

Re: Memory use in 11.11

>maxdsiz_64bit 0x80000000

This is your problem. You have it set to 2 Gb and not the default 4 Gb or even larger.