Dear Experts,
I am worrying about the system because it's using a lot of swap space. Could you please let me is that ok or I need to do something.
The system environment is below:
Redhat Linux 5.4 x86_64
Oracle DB 10gR2 (10.2.0.5)
vm.swappiness=5 (was 10 before but the effect was same)
OS CPU: 64 vcpu
OS RAM: 128GB
DB config
SGA_TARGET and SGA_MAX_SIZE = 80GB
PGA_AGGREGATE_TARGET = 25GB
session_cached_cursors = 200
Details:
[root@dbprodserv ~]# free -g
total used free shared buffers cached
Mem: 125 125 0 0 0 97
-/+ buffers/cache: 27 98
Swap: 64 31 33
SQL>select * from v$sga_target_advice
order by 2;
SGA_SIZE SGA_SIZE_FACTOR ESTD_DB_TIME ESTD_DB_TIME_FACTOR ESTD_PHYSICAL_READS
---------- --------------- ------------ ------------------- -------------------
20480 .25 329624 1.0478 59067653
40960 .5 317387 1.0089 49433939
61440 .75 315531 1.003 47726400
81920 1 314587 1 47039622
102400 1.25 313360 .9961 45962415
122880 1.5 312480 .9933 45186261
143360 1.75 311883 .9914 44682937
163840 2 311599 .9905 44414811
PGA_TARGET_FOR_ESTIMATE PGA_TARGET_FACTOR ADV BYTES_PROCESSED ESTD_EXTRA_BYTES_RW ESTD_PGA_CACHE_HIT_PERCENTAGE ESTD_OVERALLOC_COUNT
----------------------- ----------------- --- --------------- ------------------- ----------------------------- --------------------
3355443200 .125 ON 3787219551232 24986214400 99 0
6710886400 .25 ON 3787219551232 23341563904 99 0
13421772800 .5 ON 3787219551232 23341563904 99 0
20132659200 .75 ON 3787219551232 23341563904 99 0
26843545600 1 ON 3787219551232 23341563904 99 0
32212254720 1.2 ON 3787219551232 2870156288 100 0
37580963840 1.4 ON 3787219551232 2870156288 100 0
42949672960 1.6 ON 3787219551232 2870156288 100 0
48318382080 1.8 ON 3787219551232 2870156288 100 0
[root@dbprodserv ~]# sar -W
12:40:01 PM pswpin/s pswpout/s
12:50:01 PM 3.90 1179.60
01:00:01 PM 273.83 1608.86
01:10:01 PM 26.90 967.31
01:20:01 PM 78.66 509.65
01:30:01 PM 594.99 1203.06
01:40:01 PM 680.81 1266.81
01:50:01 PM 131.92 102.21
The system is a production server and got rebooted 2 days ago due to maintenance. However, it was consuming swap space so fast until around 31-33GB and sticking around there.
Thank you
KL