Re: DB time from awr
From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Wed, 11 Oct 2017 13:41:27 +0700
Message-ID: <CAP50yQ9O530NCfMR6vyc4T3AkshV8W0DYsfmRvYYsZHCwTd2oA_at_mail.gmail.com>
Date: Wed, 11 Oct 2017 13:41:27 +0700
Message-ID: <CAP50yQ9O530NCfMR6vyc4T3AkshV8W0DYsfmRvYYsZHCwTd2oA_at_mail.gmail.com>
The important bit is right here:
> Here is a sample output from a prod DB:
>
> [image: Inline image 1]
>
>
>
Within the hour the report covers, the database has spent only 4 minutes of database time. Database time includes CPU time and wait events (such as reading,writing, concurrency, etc, etc).
So, in a nutshell, your database is basically doing nothing. It's mostly idle.
-- // zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework! Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat | _at_zztat_oracleReceived on Wed Oct 11 2017 - 08:41:27 CEST
-- http://www.freelists.org/webpage/oracle-l
- image/png attachment: image.png