I need to bump up the memory allocated to an Oracle database running on Solaris 10. While I see there is currently plenty of free memory to spare, how do I view the history of free memory on Solaris over the last month? What is the exact command?
---------- Post updated at 02:55 PM ---------- Previous update was at 01:14 PM ----------
Figured out how to print the average for a given day in the last 30 days:
This prints the average freemem and freeswap for a given day in GB. Replace "saDD" with the day of the month you're interested in. For example, sa15, for the 15th day of the month.
sar -r -f /var/adm/sa/saDD | grep -i average | awk '{m=$2/1024/1024; s=$3/1024/1024; print $1, m, s;}';