CPU usage for an indivdual user
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 21 Mar 2018 10:49:59 -0500
Message-ID: <CAJvnOJY-ZCTmDV8KcRyFQRwqkO5wJWe1UY55AFg8H4wJFnx5Jw_at_mail.gmail.com>
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?
Date: Wed, 21 Mar 2018 10:49:59 -0500
Message-ID: <CAJvnOJY-ZCTmDV8KcRyFQRwqkO5wJWe1UY55AFg8H4wJFnx5Jw_at_mail.gmail.com>
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 Received on Wed Mar 21 2018 - 16:49:59 CET