Re: CPU usage for an indivdual user

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,
Andrew

On Wed, 21 Mar 2018 at 15:51, Andrew Kerber <andrew.kerber_at_gmail.com> 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.'
>

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