Assuming there is nothing of consequence running on the server other than the
oracle database instances…
I would approach this by running an AWR report on each instance (covering the
same time period in each one), and check the CPU metrics reported there, such
as:
Load Profile=>DB CPU(s) per second
Top 10 Foreground Events by Total Wait time => DB CPU => Total Wait Time (sec)
Wait Classes by Total Wait time => DB CPU => Total Wait Time (sec)
And then use instance-level measures these to weigh out shares of your total
CPU utilization.
Mike Tefft
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Mark Davidson
Sent: Wednesday, October 10, 2018 5:30 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Database CPU Usage
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