CPU Usage by Query
Posted: Thu Aug 18, 2016 10:17 pm
Hi all,
I have OEM(Oracle Enterprise Manager) installed in Vertica databases, with this, i can check the activity in the servers. It seems like there a lot of activity (100% CPU utilization) in these servers.
Is there a query or a way to know which query was generating this high CPU? Looks like this happens last May 2016, i would like to know the culprit queries.
Thanks in advance.
I have OEM(Oracle Enterprise Manager) installed in Vertica databases, with this, i can check the activity in the servers. It seems like there a lot of activity (100% CPU utilization) in these servers.
Is there a query or a way to know which query was generating this high CPU? Looks like this happens last May 2016, i would like to know the culprit queries.
Thanks in advance.