Re: Swapping Issues and ora_dbw
- From: Kenny Payton <k3nnyp@xxxxxxxxx>
- To: hilton@xxxxxxxx
- Date: Tue, 7 Oct 2014 18:59:14 -0400
If you're really interested in particular processes take a look at their
/proc/(pid)/status file. Plenty of details in there, many of which take a
kernel.org or some helpful blog to make sense of.
This is how I learned about PTE's and the memory consumption impact of
large SGA's with large numbers of connections a number of years back.
This is easy to miss in sizing hardware, especially when you're moving from
an environment with shared page tables, like Solaris.
Kenny
On Oct 7, 2014 5:26 AM, "Hilton Meyer" <hilton@xxxxxxxx> wrote:
> 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 | www.komit.co
>
>
>
> [image: Description: Description: Description: komitlogoDsigniture]
>
>
>
Other related posts:
