| Swap utilization to high [message #412499] |
Thu, 09 July 2009 14:06  |
marcossantos
Messages: 123
Registered: June 2008
|
Senior Member |
|
|
Hi,
the linux operating system is consuming 100% of swap.
Total Memory = 8GB
SGA_MAX_SIZE = 5GB
SWAP SIZE = 2GB
Thanks
Marcos Santos
|
|
|
|
|
|
|
|
|
|
| Re: Swap utilization to high [message #412527 is a reply to message #412517] |
Thu, 09 July 2009 15:31  |
marcossantos
Messages: 123
Registered: June 2008
|
Senior Member |
|
|
Hi,
1. I have to resolve this problem
with high utilization the swap on linux.
2. It have no change on operating system.
There is a process called MMAN that can be the cause.
[SIZE=2]3 PID %MEM VIRT SWAP RES CODE DATA SHR nFLT nDRT S PR NI %CPU COMMAND
12233 48.2 5151m 1.3g 3.7g 98m 2208 3.7g 83k 0 S 15 0 0 ora_mman_hygiapro
12235 20.9 5155m 3.4g 1.6g 98m 4680 1.6g 31 0 S 15 0 0 ora_dbw0_hygiapro
12343 12.3 5174m 4.1g 976m 98m 2456 955m 2178 0 S 16 0 0 oraclehygiapro (LOCAL=NO)
12355 11.7 5154m 4.1g 928m 98m 2452 921m 1962 0 S 15 0 0 oraclehygiapro (LOCAL=NO)
12241 7.2 5153m 4.5g 570m 98m 2252 565m 488 0 S 15 0 0 ora_smon_hygiapro
12389 5.4 5154m 4.6g 431m 98m 2552 425m 579 0 S 15 0 0 oraclehygiapro (LOCAL=NO)
12247 4.0 5155m 4.7g 319m 98m 2428 312m 143 0 S 15 0 0 ora_mmon_hygiapro
12245 3.0 5157m 4.8g 234m 98m 2304 225m 70 0 S 15 0 0 ora_cjq0_hygiapro
12195 2.7 619m 402m 216m 44 472m 37m 105 0 S 18 0 0 /var/dados/u01/app/oracle/product/10.2.0/db_1/jdk/bin/java -server -Xmx256M -XX:MaxPermS
19820 2.6 5158m 4.8g 204m 98m 2620 195m 1 0 S 15 0 0 oraclehygiapro (LOCAL=NO)
19904 2.5 5156m 4.8g 201m 98m 2624 194m 0 0 S 15 0 0 oraclehygiapro (LOCAL=NO)
12357 2.4 5154m 4.8g 192m 98m 2460 187m 27 0 S 15 0 0 oraclehygiapro (LOCAL=NO)
17378 1.7 5152m 4.9g 136m 98m 2320 131m 0 0 S 15 0 0 ora_j000_hygiapro
12351 1.7 5154m 4.9g 133m 98m 2452 128m 0 0 S 15 0 0 oraclehygiapro (LOCAL=NO) [/SIZE]
Thanks,
|
|
|
|
|
|
| Re: Swap utilization to high [message #412659 is a reply to message #412499] |
Fri, 10 July 2009 07:06 |
marcossantos
Messages: 123
Registered: June 2008
|
Senior Member |
|
|
Hi,
thanks!
This is result:
[oracle@prdv116 ~]$ vmstat 10 10
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------
r b swpd free buff cache si so bi bo in cs us sy id wa st
0 0 116316 52500 41576 6888772 1 1 27 35 0 1 1 0 99 0 0
0 0 116316 52640 41600 6888824 0 0 0 131 783 782 0 0 100 0 0
0 0 116316 52588 41616 6888928 0 0 5 46 121 145 0 0 100 0 0
0 0 116316 53076 41640 6889020 0 0 1 75 123 157 0 0 100 0 0
0 0 116316 71500 41664 6889112 0 0 0 45 431 442 0 0 100 0 0
Yesterday, I make this:
1. I reduce the SGA_TARGET of 5GB to 3GB.
Thanks,
|
|
|
|
|
|
| Re: Swap utilization to high [message #412669 is a reply to message #412499] |
Fri, 10 July 2009 08:34 |
marcossantos
Messages: 123
Registered: June 2008
|
Senior Member |
|
|
Hi,
SQL> show sga
Total System Global Area 5251268608 bytes
Fixed Size 2091264 bytes
Variable Size 3992979200 bytes
Database Buffers 1241513984 bytes
Redo Buffers 14684160 bytes
SQL>
SQL> show parameter sga_target
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 3G
SQL>
|
|
|
|
| Re: Swap utilization to high [message #412757 is a reply to message #412499] |
Sat, 11 July 2009 08:10 |
sruji6
Messages: 4
Registered: July 2009
|
Junior Member |
|
|
check pga_aggregate_target value & check the number of users connecting to your DB.If the number has increased the new connections will starve for PGA & generally go for swap space
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
