Frequent memory swap/paging on AIX-based Oracle servers

Posted in: Technical Track

I noticed sufficient swap/paging on AIX boxes for a Pythian client. (PAGING column in topas result). When I was investigating more about this issue, I found helpful document in Vivek Sharma ‘s blog and metalink note 316533.1.

Here is excerpt from metalink: The default values for the AIX VMM are generally not appropriate for use with relational databases.

Basically metalink recommends setting proper values for minper% and maxper% OR setting lru_file_repage to 0 in order to change AIX default virtual memory management.

Want to talk with an expert? Schedule a call with our team to get the conversation started.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *