Performance diminishes over time on AIX 7.1 due to Large Segment Aliasing
Last updated on APRIL 11, 2017
Applies to:Oracle Server - Enterprise Edition - Version 10.2.0.1 to 22.214.171.124 [Release 10.2 to 11.2]
IBM AIX on POWER Systems (64-bit)
Database performance progressively degrades over time until the instance is restarted.
This could manifested by seeing the same SQL, with the same number of buffer get, s gradually taking more and more CPU time, thereby increasing the overall elapsed time.
This addition to CPU will show up under sys time and not user time as shown in the vmstat information bleow:
This problem may be seen after migration to AIX 7.1 from lower versions of the OS.
It will usually only be experienced in RDBMS 126.96.36.199 as a result of a code change that helped to expose the issue.
RDBMS 188.8.131.52 and lower will not be likely to experience the same performance issue
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms