THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Frequent memory swap/paging on AIX-based Oracle servers

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.

Leave a Reply

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @FN_Press2: Schooner Information Technology Teams with Pythian to Deliver Advanced Support and High... http://finanznachrichten.de/20
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more