Re: Performance issue - high Free buff wait

OK, that is strange. Why do you have swap utilization at all if the memory utilization is < 40%? Second, I don't necessarily trust OEM for all metrics. I prefer sar, vmstat, iostat and dstat for Linux hosts. I also used to utilize Nigel's monitor a lot, but I'm no longer working with AIX hosts so I'm out of habit. Second, 100ms is outrageous for IO response time. That means that the IO is extremely slow. If your storage is not ASM, I would try bonnie++ to see what kind of IOPS metrics are you getting. If you are on ASM, then use SLOB.

On 1/17/21 2:59 PM, Pap wrote:
> 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

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

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