Database Instance Using Swap Space even When There is Plenty of Free RAM
Hi,
I am facinga strange issue in oracle on solaris 5.10
Platform:solaris 5.10
Database version:11.2.0.1.0
Our database Instance Using Swap Space even When There is Plenty of Free RAM.
We have 80GB of physical RAM, 32GB is set to oracle SGA_MAX_SIZE
memory parameters:
memory_max_target big integer 32G
memory_target big integer 32G
sga_max_size big integer 32G
sga_target big integer 32G
but still oracle is taking memory from swap even though we have enough physical memory.
please find the top output
load averages: 0.09, 0.18, 0.84 01:07:49
134 processes: 133 sleeping, 1 on cpu
CPU states: 99.4% idle, 0.4% user, 0.3% kernel, 0.0% iowait, 0.0% swap
Memory: 80G real, 69G free, 35G swap in use, 49G swap free
PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
1052 oracle 13 59 0 95M 66M sleep 13:16 0.07% oraagent.bin
10256 oracle 1 59 0 32G 835M sleep 0:00 0.03% oracle
1227 oracle 15 59 0 78M 56M sleep 4:27 0.02% ocssd.bin
9524 vector1 112 59 0 1704M 776M sleep 45:04 0.02% java
988 oracle 38 59 0 119M 92M sleep 3:00 0.02% ohasd.bin
1297 oracle 1 101 -20 453M 390M sleep 2:47 0.02% oracle
1765 oracle 1 101 -20 32G 329M sleep 2:45 0.02% oracle
10258 oracle 1 59 0 32G 345M sleep 0:00 0.02% oracle
10259 oracle 1 59 0 3400K 2024K cpu/20 0:00 0.01% top
1777 oracle 1 59 0 32G 342M sleep 1:14 0.01% oracle
1246 oracle 6 59 0 56M 44M sleep 1:22 0.01% diskmon.bin
1803 oracle 1 59 0 32G 514M sleep 0:30 0.01% oracle
1215 oracle 15 59 0 71M 46M sleep 1:12 0.00% cssdagent
1307 oracle 1 59 0 453M 390M sleep 0:45 0.00% oracle
1217 oracle 11 59 0 81M 49M sleep 0:35 0.00% orarootagent.bi
Vmstat output:
$vmstat 5 5
kthr memory page disk faults cpu
r b w swap free re mf pi po fr de sr s3 s3 s3 s3 in sy cs us sy id
0 0 0 53698448 73900568 20 81 32 6 5 0 1 -0 0 1 -0 2235 1447 1984 1 0 99
0 0 0 51196160 72037552 1 13 0 0 0 0 0 0 0 0 0 2505 1403 2204 0 0 100
0 0 0 51193488 72035864 55 380 0 0 0 0 0 0 0 0 0 2487 2143 2203 0 1 99
0 0 0 51183856 72030176 0 0 0 3 3 0 0 0 0 0 0 2496 1370 2182 0 0 99
0 0 0 51182648 72029112 22 117 0 0 0 0 0 0 0 0 0 2503 1408 2193 1 0 99
$cat /etc/release
Solaris 10 10/09 s10s_u8wos_08a SPARC
Copyright 2009 Sun Microsystems, Inc. All Rights Reserved.
Use is subject to license terms.
Assembled 16 September 2009
I refered the metalink document id: [ID 761960.1]
Database Instance Using Swap Space When There is Plenty of Free RAM metalink note [ID 761960.1]
and tried the disabling the sga_max_size and memory_max_target and memory target with all different combination but no use.
We have one more box where same setup was configured in solaris platform but there the above memory parameters are not disabled but it is not using swap space it takes memry only from physical RAM
Can any one throw some lights on this issue. It wopuld be great if I come to know where the exact problem
Thanks in advance
With Regards,
Boobathi P