As I was refreshing a dev database and checking out the alert log I noticed the following message:
1 2 3 4 |
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 […]