RE: To Swap, or not to Swap

  • From: "Clay Jackson" <dmarc-noreply@xxxxxxxxxxxxx> ("Clay.Jackson")
  • To: "gogala.mladen@xxxxxxxxx" <gogala.mladen@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 3 Apr 2023 20:11:57 +0000

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@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@xxxxxxxxx<mailto:clay.jackson@xxxxxxxxx>
office  949-754-1203  mobile 425-802-9603

From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf 
Of Mladen Gogala
Sent: Monday, April 3, 2023 11:20 AM
To: oracle-l@xxxxxxxxxxxxx
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>

JPEG image

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2023