Re: To Swap, or not to Swap

On 4/2/23 19:12, Jared Still wrote:
> So, I would like to devise some testing for this, with and without swap.
>
> Suggestions for metrics to track?
>
There is a file /proc/pressure/memory which tracks tasks stalled on the resource. The description is here:

https://docs.kernel.org/accounting/psi.html

The system without pressure looks like this:

/home/mgogala/bin# cat /proc/pressure/memory some avg10=0.00 avg60=0.00 avg300=0.00 total=0 full avg10=0.00 avg60=0.00 avg300=0.00 total=0

If anything here was larger than zero, that would be the indication of memory pressure. It would be easy to write a Perl script which would start playing "Under Pressure" by Queen whenever there is memory pressure. If there was insufficient space in your database, another script could play "Space Oddity" by David Bowie. When there is a problem with the full table scan, the tune would be "I'm Bad" by the late M. Jackson. That's what sound-coding alerts would look like.

Now I realize that Oracle needs an interface to Spotify.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l