RE: To Swap, or not to Swap

Mladan – do you mean something like this?

https://www.quest.com/community/blogs/b/performance-monitoring/posts/foglight-play-some-funky-music<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.quest.com%2Fcommunity%2Fblogs%2Fb%2Fperformance-monitoring%2Fposts%2Ffoglight-play-some-funky-music&data=05%7C01%7CClay.Jackson%40quest.com%7C08149bd8775a475254f408db347259d0%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638161437979879178%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=vMQE9q9V%2FLrrO5CVvahp5Hrfw3TCLFPEJMZduLriqsk%3D&reserved=0>

😊

Clay Jackson
Database Solutions Sales Engineer
[cid:image001.jpg_at_01D9662D.DCC379E0]<https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.quest.com%2Fsolutions%2Fdatabase-performance-monitoring%2F&data=02%7C01%7CClay.Jackson%40quest.com%7C6c57a6f83b6c490b3b4708d83edb5e24%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637328459211276950&sdata=QId%2B4IzV9yh9ogPm8bagnDkPxeBziolrNZGcYO8%2FrYk%3D&reserved=0> clay.jackson_at_quest.com<mailto:clay.jackson_at_quest.com> office 949-754-1203 mobile 425-802-9603

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mladen Gogala Sent: Monday, April 3, 2023 11:20 AM
To: oracle-l_at_freelists.org
Subject: Re: To Swap, or not to Swap

CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe.

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<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.kernel.org%2Faccounting%2Fpsi.html&data=05%7C01%7Cclay.jackson%40quest.com%7C8ad28da6866a4aa0dce308db34702ee7%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638161428683304105%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=dhgDsRXBPU8fQ2NwguofwtWKHJTJbZI5A%2FF3vi7dSCc%3D&reserved=0>

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<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdbwhisperer.wordpress.com%2F&data=05%7C01%7Cclay.jackson%40quest.com%7C8ad28da6866a4aa0dce308db34702ee7%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638161428683304105%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=bGK0t2DO0ZY8cyGLFuLle6OYm4n7pCQxMW56XV%2F0QP8%3D&reserved=0>

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






(image/jpeg attachment: image001.jpg)