CPU Utilization used by each database on a multi-db server
Hi,
I hope someone can help me.
Scenario:
2 DB's sharing the same server. Do you know how we can tell how much CPU util (%) is used per database? For example if total CPU util is 30%, how can I find out out of the 30% how much is used?
I've tried using using the 'Host CPU Utilization (%)' metric name from the DBA_HIST_SYSMETRIC_SUMMARY view but that actually shows higher percentage than what OEM & sar shows, so that view can't be giving me the correct value.
The only option I have so far is to produce a graph with 2 data series, 1 for total CPU util and 1 showing the CPU util in user mode.
Kind Regards,
Bjorn Aarhus
OOD