Re: Server is swapping with free memory available
Date: Tue, 19 Mar 2019 20:36:52 -0400
Message-ID: <CAFQ5ACL4zQgmcimtJWqduuACsNFhWnM6TzSFgyKMGzuKdPF8Wg_at_mail.gmail.com>
Arr you using hugepages?
On Tue, Mar 19, 2019, 19:40 <dimensional.dba_at_comcast.net> wrote:
> Is your database currently swapping as in active pages moving in and out
> of swap?
>
> vmstat 5 200
>
>
>
> Does the si and so columns have anything besides 0?
>
>
>
> Or do you just have swap being consumed by processes from some previous
> over whelm of memory event?
>
>
>
> What specific processes are using swap?
>
>
>
> Need to run as root to see everything
>
> for file in /proc/*/status ; do awk '/VmSwap|Name/{printf $2 " " $3}END{
> print ""}' $file; done | awk '$3 == "kB" && $2 != 0 {print $1" "$2" "$3 }'
>
>
>
>
>
>
>
>
>
>
>
> *Matthew Parker*
>
> *Chief Technologist*
>
> *Dimensional DBA*
>
> *Oracle Gold Partner*
>
> *425-891-7934 (cell)*
>
> *D&B *047931344
>
> *CAGE *7J5S7
>
> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
> www.dimensionaldba.com
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Mladen Gogala
> *Sent:* Tuesday, March 19, 2019 3:52 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: Server is swapping with free memory available
>
>
>
> Have you tried with FILESYSYSTEMIO_OPTIONS=ALL?
>
>
>
> On 3/19/19 4:54 PM, Upendra nerilla wrote:
>
>
>
> Hello everyone -
>
> We have a database server which is choosing to swap though there is plenty
> of free memory.
>
> Any pointers on what to check are much appreciated..
>
>
>
> --
>
> Mladen Gogala
>
> Database Consultant
>
> Tel: (347) 321-1217
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 20 2019 - 01:36:52 CET