Re: Performance issue - high Free buff wait

Have you tried looking into the overall system response? CPU, paging, disk performance and queue length, network performance (dropped or re-transmitted packets, errors on the interface, connection timeouts)? Also, have you tried using SQL TRACE? SQL TRACE is still the only real way of tuning the applications.

Regards

On 1/17/2021 6:15 AM, Pap wrote:
> Another doubt I had was  if the dB writer response time of 100ms
> during that issue period is the cause or the result of slowness? If
> it's the cause can asynch IO setup for data file help improve
> situation here? Or by just making row by row operations converted to
> batch will be enough ?

-- 
Mladen Gogala

Oracle DBA

Tel: (347) 321-1217


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