filesystemio_options 12.2
From: pier paolo Bruno <pbrunoster_at_gmail.com>
Date: Fri, 8 Nov 2024 22:31:25 +0100
Message-ID: <CA+dM1yNoAoHVEJWDtZmmSW6f4t0xum0d3uPU9a-ESht9BXjSxA_at_mail.gmail.com>
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
Date: Fri, 8 Nov 2024 22:31:25 +0100
Message-ID: <CA+dM1yNoAoHVEJWDtZmmSW6f4t0xum0d3uPU9a-ESht9BXjSxA_at_mail.gmail.com>
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 Received on Fri Nov 08 2024 - 22:31:25 CET