Swapping Issues and ora_dbw
Date: Tue, 7 Oct 2014 09:25:18 +0000
Message-ID: <a8b1f98c62e64032b6af8824f8823177_at_AM3PR06MB404.eurprd06.prod.outlook.com>
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_at_komit.co | www.komit.co<http://www.komit.co/>
[Description: Description: Description: komitlogoDsigniture]
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 07 2014 - 11:25:18 CEST