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@xxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
