Home » Infrastructure » Linux » Swap utilization to high (Oracle 10g 10.2.0.4 RHEL5 x68_64)
Swap utilization to high [message #412499] Thu, 09 July 2009 14:06 Go to next message
marcossantos
Messages: 114
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 #412503 is a reply to message #412499] Thu, 09 July 2009 14:24 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
My condolences.
Re: Swap utilization to high [message #412513 is a reply to message #412503] Thu, 09 July 2009 14:48 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,
for what?
I dont understood.
Can you help me?

Thanks,
Marcos Santos
Re: Swap utilization to high [message #412517 is a reply to message #412499] Thu, 09 July 2009 14:59 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>Can you help me?
Help you with what?
You have an Operating System issue.

When did the problem start?
What changed just before start of problem?

[Updated on: Thu, 09 July 2009 14:59]

Report message to a moderator

Re: Swap utilization to high [message #412527 is a reply to message #412517] Thu, 09 July 2009 15:31 Go to previous messageGo to next message
marcossantos
Messages: 114
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 #412532 is a reply to message #412499] Thu, 09 July 2009 16:00 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>1. I have to resolve this problem with high utilization the swap on linux.
Forgive me, but I need to see some evidence a problem actually exists.

What metrics do you have that every will agree a problem exists?

If "nothing" has changed, why do you have a problem today & not last week?

post results from command below using <code tags>
vmstat 10 10
Re: Swap utilization to high [message #412659 is a reply to message #412499] Fri, 10 July 2009 07:06 Go to previous messageGo to next message
marcossantos
Messages: 114
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 #412662 is a reply to message #412659] Fri, 10 July 2009 07:27 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
1. I reduce the SGA_TARGET of 5GB to 3GB.


If you don't mind once again confirm current SGA_MAX_SIZE & SGA_TARGET value?

Thanks
Re: Swap utilization to high [message #412669 is a reply to message #412499] Fri, 10 July 2009 08:34 Go to previous messageGo to next message
marcossantos
Messages: 114
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 Go to previous message
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

Previous Topic: Error message when loading oracle via web browser
Next Topic: Installing 11g Enterprise on Ubuntu Server 8.04 LTS 64 bit
Goto Forum:
  


Current Time: Sun Dec 04 08:57:39 CST 2016

Total time taken to generate the page: 0.10636 seconds