Re: Server is swapping with free memory available

From: Upendra nerilla <nupendra_at_hotmail.com>
Date: Wed, 20 Mar 2019 03:26:29 +0000
Message-ID: <DM5PR10MB17388F8CAAB43EFEFC3A4751D8410_at_DM5PR10MB1738.namprd10.prod.outlook.com>

Not using hugepages as of now, I am looking into implementing it though.

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Mark J. Bobak <mark_at_bobak.net> Sent: Tuesday, March 19, 2019 8:36 PM
To: dimensional.dba_at_comcast.net
Cc: gogala.mladen_at_gmail.com; oracle-l_at_freelists.org Subject: Re: Server is swapping with free memory available

Arr you using hugepages?

On Tue, Mar 19, 2019, 19:40 <dimensional.dba_at_comcast.net<mailto: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<mailto: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<http://www.dimensionaldba.com/>

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto: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<mailto: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-l Received on Wed Mar 20 2019 - 04:26:29 CET