Re: CPU usage for an indivdual user

From: Andy Sayer <>
Date: Wed, 21 Mar 2018 16:35:53 +0000
Message-ID: <>

Hi Andrew

This may be over thinking it, or it might be a perfect set up for what you’ll end up doing anyway.

You can create resource manager consumer group mapping’s for each of your application usernames, each user gets defaulted to a different consumer group. Their cpu stats (and other info) will get aggregated by consumer group and sent to v$rsrcMgrMetric and v$rsrcMgrMetric_history.

You can then use this information to plan a resource management plan if you wished.

Hope that helps,

On Wed, 21 Mar 2018 at 15:51, Andrew Kerber <> wrote:

> I have a case where I need to find out how much CPU individual oracle
> users are using. It looks like we have a high percentage of dynamic sql
> that is causing a lot of CPU usage due to hard parsing, but we are having
> trouble nailing it down to an individual application. Each application runs
> under its own username, so I need some way to figure out the CPU
> utilization for each username. Any ideas?
> --
> Andrew W. Kerber
> 'If at first you dont succeed, dont take up skydiving.'

Received on Wed Mar 21 2018 - 17:35:53 CET

Original text of this message