AWR report reading
From: Ram Raman <veeeraman_at_gmail.com>
Date: Tue, 30 Jun 2020 17:06:09 -0500
Message-ID: <CAHSa0M04SHrB3mZVspzsOmR86jQGc3ddrLVghJ6He=WFki_=3g_at_mail.gmail.com>
Apologies if this is already answered elsewhere. I came across this today:
Scheduler 8 0 0.20 .0 0.0
Date: Tue, 30 Jun 2020 17:06:09 -0500
Message-ID: <CAHSa0M04SHrB3mZVspzsOmR86jQGc3ddrLVghJ6He=WFki_=3g_at_mail.gmail.com>
Apologies if this is already answered elsewhere. I came across this today:
Wait Classes by Total Wait Time
Wait ClassWaitsTotal Wait Time (sec)Avg Wait (ms)% DB timeAvg 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 - 00:06:09 CEST