RE: Database CPU Usage

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark Davidson Sent: Wednesday, October 10, 2018 5:30 PM To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l