As I was refreshing a dev database and checking out the alert log I noticed the following message:
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [3.00%] pct of memory swapped out [0.00%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.
To make sure it wasn’t to do with the refresh I looked at other database alert logs and history and found that this message has been constantly appearing in all logs for the last 6 months…