Sunday, February 20, 2011

Oracle running on HP-UX 11.31 memory problem

Problem: Still not enough memory, although I decreased memory_max_target and memory_target together with increasing the swap disk size.

Cause: HP-UX kernel parameter tunable filecache_max parameter utilizes the memory hungrily.

Solution: Decreasing filecache_max and filecache_min parameters 5% and 3% respectively solved my problem. The rationale behind this is: "let oracle SGA to utilize and cache the datafiles".

For an example case, you could look at: http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1298195390914+28353475&threadId=1448215

No comments:

Windows (powershell) counterparts of Linux commands

You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...