11.2.0.3 Database Performs Slow and Increase In Paging On AIX 7.1 Power Server 64 bit

Posted: August 3, 2014 in Database General
Tags: , , , ,

After upgrading to 11.2.0.3 on AIX 7.1 Power system 64-bit systems we have experienced slow performance of database and high paging on AIX server. This is a general slowness with all the memory (Physical + Virtual) consumed in some time. Restarting of database didn’t help as memory does not get free after shutting down the database. Only server restart helps but that is again temporary.

Symptoms includes that background processed start taking more memory. After bearing with this issue, finally we got the issue as AIX 7.1 power system 64-bit bug due to which memory once occupied doesn’t get free on server. Both Oracle & IBM have note related to this issue and fix is to apply a patch on AIX system. Below are use full docs from Oracle & IBM which helped us. These are worth to look at if you are also having above symptoms.

Virtual Memory Consumption / Paging under AIX 7.1 (Doc ID 1666458.1)

Memory Consumption on AIX (Doc ID 259983.1)

http://www-01.ibm.com/support/docview.wss?uid=isg1IV53587

After applying the patch mentioned in above notes, issue is resolved. Hope this will help to others facing this slowness issue for which we spend few weeks to find out.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s