1751698 Members
5086 Online
108781 Solutions
New Discussion юеВ

Re: 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 3
Dennis Handly
Acclaimed Contributor

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 ;-)
Dennis Handly
Acclaimed Contributor

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.