That makes sense.. Thanks for the information.
________________________________
From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
Sent: Tuesday, March 19, 2019 10:54 PM
To: Upendra nerilla; oracle-l@xxxxxxxxxxxxx
Subject: Re: Server is swapping with free memory available
It will help you eliminate IO buffering in the kernel space and move it to user
space. Without using direct IO, you have double buffering: your database blocks
are cached in SGA and in the OS buffer cache.
On 3/19/19 10:44 PM, Upendra nerilla wrote:
A few more details:
* Current settings: filesystemio_options=asynch. -- We haven't tried
"ALL", trying to understand how it will help with the swap issue?
-Upendra
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx><mailto:oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Mladen Gogala <gogala.mladen@xxxxxxxxx><mailto:gogala.mladen@xxxxxxxxx>
Sent: Tuesday, March 19, 2019 6:52 PM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217