swap space

[Roshan]

Oracle DB 12.1.0.2
RAC 2 nodes
Solaris 11
RAM on each node: 80G
swap space on each node: 128G

Hi Erman,

I would like to know what will happen if swap space becomes 0? currently there is 100G free space out of 128G for swap space.

As per result below, system is not short of memory

ora12c@dware1:~$ /usr/bin/ps -e -o pid,rss,args|egrep 'sched|pageout|fsflush'|grep -v grep
    0        0 sched
    2        0 pageout
    3        0 fsflush
ora12c@dware1:~$ vmstat 1 5|awk '{print $8 " " $9}'

pi po
57 110
0 0
0 0
0 0
0 0
You have new mail in /var/mail/ora12c

ora12c@dware1:~$ vmstat 1 2
 kthr      memory            page            disk          faults      cpu
 r b w   swap  free  re  mf pi po fr de sr am s0 s1 s2   in   sy   cs us sy id
 0 0 72 136630312 9585608 1747 3014 57 110 96 0 2 9 225 63 5 17351 26533 33525 3 2 96
 0 0 209 138784288 8420592 117 5496 0 0 0 0 0 0 61 2 0 11850 17134 16135 2 1 97
ora12c@dware1:~

Regards,

Roshan

[ErmanArslansOracleBlog]

In Solaris, there are 2 types of swap usage.

1)Physical -- when you have no space left, your programs will not fail, but you will probably see a performance degradation.
2)Virtual - when you have no space left, your malloc() calls may fail, so your programs may start to fail.

I m not a soalris expert, but what I can tell you is, you need to ensure that neither of these swap space is exhausted.

You may want to look the book named -> Solaris Internals: Core Kernel Components , Authors: Jim Mauro, Richard McDougall