Re: To Swap, or not to Swap

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 30 Mar 2023 13:03:08 -0400
Message-ID: <CAP79kiTS=cqid3WqKvUE14y4+pZsPUOAbvGkH5sJm42aiKx4UQ_at_mail.gmail.com>



Also when you have an unexpected memory leak and your DB server is bleeding to death, swapping is a good way to catch it! WIthout swap space the crash is a lot more violent.

Chris

On Thu, Mar 30, 2023 at 12:50 PM Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> Oracle still calls for 16G swap regardless of how large the server memory
> is, and I have seen it used unexpectedly on occasion. SO yes, its a good
> idea to have a swap partition available.
>
> On Thu, Mar 30, 2023 at 11:36 AM Clay Jackson <dmarc-noreply_at_freelists.org>
> wrote:
>
>> Hey, Jared!
>>
>>
>>
>> My personal take is that there are still enough “ill-behaved”
>> applications out there that having at least SOME swap allocated is a
>> “defensive best practice”.
>>
>>
>>
>> Among other things, the consequences of NOT having it can be extreme.
>>
>>
>>
>> Maybe not the “old standard” 2x RAM; but at least some cushion that would
>> allow someone monitoring the system (you DO monitor that, right) to find
>> and fix issue before they become a “problem”.
>>
>>
>>
>> Clay Jackson
>>
>>
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
>> Behalf Of *Jared Still
>> *Sent:* Thursday, March 30, 2023 9:25 AM
>> *To:* Oracle-L Freelists <oracle-l_at_freelists.org>
>> *Subject:* 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.
>>
>>
>>
>> That is the question.
>>
>>
>>
>> I am curious about current thoughts on having or not having a swap
>> partition on Linux based Oracle servers.
>>
>>
>>
>> Let's assume typical production standard servers with a reasonable amount
>> of RAM, sway 256G or more.
>>
>>
>>
>> I have some thoughts on this myself, but would like to see others'
>> thoughts on this.
>>
>>
>>
>>
>>
>> Jared Still
>> Certifiable Oracle DBA and Part Time Perl Evangelist
>>
>> Principal Consultant at Pythian
>>
>> Oracle ACE Alumni
>>
>> Pythian Blog http://www.pythian.com/blog/author/still/
>> <https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.pythian.com%2Fblog%2Fauthor%2Fstill%2F&data=05%7C01%7Cclay.jackson%40quest.com%7C250c544a0b96430f499208db313b61cd%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638157903370449294%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=m42SdJxJfHF0UwrVGWWNpbkomWnBLAGiaX7ERd13ZNk%3D&reserved=0>
>>
>> Github: https://github.com/jkstill
>> <https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fjkstill&data=05%7C01%7Cclay.jackson%40quest.com%7C250c544a0b96430f499208db313b61cd%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638157903370449294%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=p37KCRpodzzsJmSQHSPrEkB8sKnMEX1WxuCfmeQ8C8o%3D&reserved=0>
>>
>> Personality: http://www.personalitypage.com/INTJ.html
>> <https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.personalitypage.com%2FINTJ.html&data=05%7C01%7Cclay.jackson%40quest.com%7C250c544a0b96430f499208db313b61cd%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638157903370449294%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=DbM4Z6IkgvFJca1jlYh2PmyMMKcH6Jko0976hnXeaR0%3D&reserved=0>
>>
>>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 30 2023 - 19:03:08 CEST

Original text of this message