Re: AWR report reading

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 30 Jun 2020 18:50:14 -0500
Message-Id: <E094D78D-0308-4BC6-85E3-4C3AA1647186_at_gmail.com>



user io is part of system io i think.

Sent from my iPhone

> On Jun 30, 2020, at 5:15 PM, Ram Raman <veeeraman_at_gmail.com> wrote:
>
> 
> Apologies if this is already answered elsewhere. I came across this today:
>
> Wait Classes by Total Wait Time
>
> Wait Class Waits Total Wait Time (sec) Avg Wait (ms) % DB time Avg Active Sessions
> System I/O 14,677 4,485 305.60 100.3 2.5
> User I/O 281,109 4,128 14.69 92.3 2.3
> Other 3,498 241 68.84 5.4 0.1
> DB CPU 123 2.7 0.1
> Commit 751 33 43.60 .7 0.0
> Application 10 29 2870.26 .6 0.0
> Concurrency 1,384 2 1.56 .0 0.0
> Network 4,691 0 0.04 .0 0.0
> Configuration 1 0 144.65 .0 0.0
> Scheduler 8 0 0.20 .0 0.0
> Host CPU
>
>
> I can understand the DB time greater than wall clock time. But how can "%DB time" be way over 100%? Or am I not interpreting this correctly? v12.1 on Linux.
>
> Thanks
> Ram.
>
> --
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 01 2020 - 01:50:14 CEST

Original text of this message