AIX: Database performance gets slower the longer the database is running
Last updated on MARCH 21, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
z*OBSOLETE: Bull Escala RL AIX (64-bit)
IBM AIX on POWER Systems (64-bit)
IBM AIX on POWER Systems (32-bit)
z*OBSOLETE: IBM AIX 4.3 Based Systems (64-bit)
IBM AIX Based Systems (64-bit)IBM AIX Based Systems (32-bit)Bull Escala RL AIX (64-bit)IBM AIX 4.3 Based Systems (64-bit)
Oracle databases running on AIX based systems.
Database performance continues to get slower and slower the longer the database is left running. You may also notice a continuing increase in the amount of paging space usage the longer the database is left running. However, database performance returns to normal after rebooting the system, or shutting down and restarting the database.
The slowdown can appear as increased latch contention for system critical latches such as the "library cache" and "shared pool" latches.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms