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@xxxxxxxxx> 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.