Re: Performance issue - high Free buff wait

Actually the CPU utilization of the host is staying ~70-75% consistently and memory utilization is staying <40% and swap utilization <18%, this is what I can see on the OEM for the Host and as i mentioned earlier it contains 4-5 different databases including this one. I have not turned on the sql trace, but do you mean by 10046 trace? I am not sure if turning this On at system level is possible and also will help us in analyzing the issue here as because it may not related to one sql rather multiple sql submitting to the database at this point.

Regards
Pap

On Sun, Jan 17, 2021 at 11:55 PM Gogala, Mladen <gogala.mladen_at_gmail.com> wrote:

> 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
>
>
>

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