RDBMS version: 19c
OS : Red Hat Enterprise Linux Server release 7.9 (Maipo)
I have a DB running on RHEL 7.9. The DB server is a VM in VMWare ESX.
Datafiles are stored in XFS filesystem.
filesystemio_options is set to NONE.
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL> show parameter filesystemio
PARAMETER_NAME TYPE VALUE
-------------------- -------------------- ------------------------------
filesystemio_options string none
I can see 9GB is swapped out to disk.
Does the output below show the RAM consumption is high ?
I see free = 0 for "Mem:" so I think the server is short of RAM as well. I find Linux free command's output a bit confusing
$ free -g
total used free shared buff/cache available
Mem: 48 9 0 28 38 10
Swap: 15 9 6
Since filesystemio_options is not set to directIO in the DB, I was wondering if the DB blocks read from the data files are stored in both Oracle's SGA and Linux memory buffer cache, which is bad.
Could this be the cause of too much swapping ?