Re: Database CPU Usage
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Thu, 11 Oct 2018 01:14:27 +0300
Message-ID: <CAOVevU7V_qBY1DxofZKRiwn97Cv3kmMJXREtv+A5yc6iV=2nFA_at_mail.gmail.com>
Date: Thu, 11 Oct 2018 01:14:27 +0300
Message-ID: <CAOVevU7V_qBY1DxofZKRiwn97Cv3kmMJXREtv+A5yc6iV=2nFA_at_mail.gmail.com>
Hi Mark,
I like to get such information from v$sysmetric: select * from v$sysmetric where metric_name like '%CPU%'
On Thu, Oct 11, 2018 at 12:31 AM Mark Davidson <wdavidsmc_at_gmail.com> wrote:
> Where can I find information on calculating how much CPU an entire
> database instance is using (on average)? I have several databases running
> and I need to understand how much each is using. For example, if my current
> utilization is 40%, what % is each database.
>
> Regards,
> Mark
>
>
-- Best regards, Sayan Malakshinov Oracle performance tuning engineer Oracle ACE Associate http://orasql.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 11 2018 - 00:14:27 CEST