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@xxxxxxxxx>
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@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> *On
Behalf Of *Jared Still
*Sent:* Thursday, March 30, 2023 9:25 AM
*To:* Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
*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.'
