RE: filesystemio_options 12.2

That is one of the gotchas with FS based databases. You need to set filesystemio_options=setall You need to determine what is in swap and then change settings accordingly. I have had mostly in the past it is the pga settings causing the swapping, not normally the SGa itself.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of pier paolo Bruno Sent: Friday, November 8, 2024 1:31 PM
To: oracle list <oracle-l_at_freelists.org> Subject: filesystemio_options 12.2

Hi, i have single instance database on linux , ext4 . it is a 12.2, with patchset April 2020 on top. I have performance problems.
The first thing i see is that the server is swapping. It is a vm with 23gb of ram and an instance with 12g sga. if i do vmstat -m or free .m i see that buffer/cache is 14gb . I have also seen that filesystemio_options is set to none. Is that correct ? would not be better to set it to set_all and try to not rely on filesystem cache as it was on older releases ? I tried to check support and documentation, i still see that parameter is till there but i find notes for the most on older releases ( 9.. 10.. .11 ) and so i asked myself if it was something till to use . Thanks
Pier Paolo
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 08 2024 - 23:20:17 CET