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@xxxxxxxxx> 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.'
