Re: Performance issue - high Free buff wait

You have a royal mess there. Free buffer waits mean that you need more free buffers, You can buy some free buffers from Kingston. The good news is that this year you will be able to buy DDR5:

https://www.pcgamesn.com/ddr5-ram-release-2021

Oracle 11 server with low memory makes me think that your server is a real candidate for lightning fast RAM and an appropriate CPU.

Second, the number of waits is meaningless without the time spent waiting. An AWR report would have given you a better picture.

Regards

On 1/13/21 9:04 AM, Pap wrote:
>
> *Below is count of waits from Dba_hist_active_sess_history for that
> ~15minutes window:-*
>
> Top two(log file sync and db file async I/O submit) are not associated
> with application user/session.
>
> EVENT COUNT(*)
> log file sync 260
> db file async I/O submit 188
> free buffer waits 72
> 66
> 65
> 63
> 62
> db file sequential read 56
> write complete waits 54
> 54
> db file sequential read 51
>
> Regards
>

-- 
Mladen Gogala
Database Consultant
http://mgogala.byethost5.com


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