tag:blogger.com,1999:blog-1550840387946350137.post6067542055442190258..comments2022-04-03T00:39:35.304-07:00Comments on Performance Engineering and Capacity Planning: ora-4030 errors and swap sizing on DataWarehousing platformsUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1550840387946350137.post-3773668666407613442011-07-08T23:58:46.817-07:002011-07-08T23:58:46.817-07:00"This is also on the Solaris platform, though..."This is also on the Solaris platform, though a similar analogy could work on Linux too."<br /><br />Linux doesn't know the concept of swap reservations (i.e., unless you tell it to), and additionally has a very sophisticated COW mechanism to share memory pages. I've personally seen Oracle servers (OLTP though) that committed > 200GB of anonymous RAM on a server with 16GB DIMMs + 16GB swap.<br /><br />This is a real advantage with modern systems. You're running into severe issues with those modern boxes with 512GB of DIMMs or so. To seriously use such an amount of space with Solaris, you need another 512GB (!) of swapspace only for swap reservation, even if you never really dip into it. A Linux on the same server will happily go > 80% memory used w/out any swapspace, and can be run with, say, 32GB of swapspace (even with todays HDDs, your customer will be on the phone once you're in the area of 10GB swap used ;-).<br /><br />Best regards,<br /><br />Gunnar "Nick" BluthHnnar "Nick" Bluthnoreply@blogger.comtag:blogger.com,1999:blog-1550840387946350137.post-23718638192004414582010-02-25T11:33:17.777-08:002010-02-25T11:33:17.777-08:00What if this occurs on Windows Server because it h...What if this occurs on Windows Server because it has no swap space ,how do I investigate the source of the problem or cause ?Jabulanihttps://www.blogger.com/profile/08538329867330510722noreply@blogger.com