RE: Swapping Issues and ora_dbw
- From: Hilton Meyer <hilton@xxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Oct 2014 07:26:52 +0000
Thanks for the suggestions folks. I looked at the PGA and SGA targets and they
were super high.
I lowered them to SGA Target 4GB and PGA Target 2GB on each of the instances
and restarted.
Things look better already and I'll keep an eye on the issue.
Thanks again for the help,
Hilton Meyer
Database Administrator
Phone: +972-52-7908599
Office: +972-52-7908600 Fax: 1535-27908600
hilton@xxxxxxxx | www.komit.co<http://www.komit.co/>
[Description: Description: Description: komitlogoDsigniture]
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Hilton Meyer
Sent: Wednesday, October 08, 2014 8:29 AM
To: Mark W. Farnham; oracle-l@xxxxxxxxxxxxx
Subject: RE: Swapping Issues and ora_dbw
Here is the full commands and outputs:
# top -c
top - 08:15:23 up 26 days, 21:15, 4 users, load average: 1.80, 2.20, 2.55
Tasks: 613 total, 5 running, 608 sleeping, 0 stopped, 0 zombie
Cpu(s): 20.3%us, 3.9%sy, 0.0%ni, 68.2%id, 7.4%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 49557132k total, 49264636k used, 292496k free, 49236k buffers
Swap: 8257532k total, 7888592k used, 368940k free, 42721744k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
49069 oradev 20 0 12.2g 10g 9g S 0.0 21.2 41:58.61 ora_dbw0_DEV
49073 oradev 20 0 12.2g 9g 9g S 0.0 21.1 41:58.67 ora_dbw1_DEV
4716 orapatch 20 0 12.2g 8.5g 8.5g S 0.0 17.9 34:21.58 ora_dbw1_PATCH
4712 orapatch 20 0 12.2g 8.5g 8.4g S 0.0 17.9 32:42.16 ora_dbw0_PATCH
.
.
.
# free -m
total used free shared buffers cached
Mem: 48395 48106 288 0 55 41525
-/+ buffers/cache: 6525 41870
Swap: 8063 7724 339
Thanks,
Hilton Meyer
Database Administrator
Phone: +972-52-7908599
Office: +972-52-7908600 Fax: 1535-27908600
hilton@xxxxxxxx<mailto:hilton@xxxxxxxx> | www.komit.co<http://www.komit.co/>
[Description: Description: Description: komitlogoDsigniture]
From: Mark W. Farnham [mailto:mwf@xxxxxxxx]
Sent: Tuesday, October 07, 2014 5:40 PM
To: Hilton Meyer; oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: RE: Swapping Issues and ora_dbw
1) tell us the command (some variety of ps?)
2) give us a head -2 of the command results so we can see the headings as
well as the lines you care about
3) without knowing the tool, is it one that reports the combined sum of
memory used by the process as well as any shared memory attached during its
run? IF so, then easily up to your sga size could be a complete red herring in
considering the amount of memory a process is holding
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hilton Meyer
Sent: Tuesday, October 07, 2014 5:25 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Swapping Issues and ora_dbw
Hi there,
I have a test server with three instances running and I have been seeing that
swapping issues.
The server is running out of swap space, been flirting on the edge of 0.
I dug a little deeper an found that the main culprits are two of the instances:
49069 oradev 20 0 12.2g 10g 10g S 0.0 21.5 40:44.19 ora_dbw0_DEV
49073 oradev 20 0 12.2g 10g 10g S 0.0 21.5 40:43.90 ora_dbw1_DEV
4716 orapatch 20 0 12.2g 8.5g 8.5g S 0.0 17.9 33:20.19 ora_dbw1_PATCH
4712 orapatch 20 0 12.2g 8.4g 8.4g S 0.0 17.9 31:45.49 ora_dbw0_PATCH
The weird thing is the third instance does not register although they are the
same clone from the Production instance.
Few questions:
* Is this not an unusually high percentage of memory for the process to
hold?
* Is there a way to release the memory back to the server?
* Is there a way for me to dig deeper to find out why these two
instances are holding so much memory?
Sys Info:
EBS R12.1.3
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Linux 2.6.39-400.210.2.el5uek
Thanks,
Hilton Meyer
Database Administrator
Phone: +972-52-7908599
Office: +972-52-7908600 Fax: 1535-27908600
hilton@xxxxxxxx<mailto:hilton@xxxxxxxx> | www.komit.co<http://www.komit.co/>
[Description: Description: Description: komitlogoDsigniture]
Other related posts:
