Oracle - relating CPU usage to DB User or OS User

Question

I need a way of relating the CPU load within an Oracle database to an OS User name. Looking through the reports, I can see how to get reports by db user & os user, but they are all just displaying wait time. I need a similar report that reflects % of CPU consumed by those users.

I should mention, the DPA repo is SQL Server, the database I'm monitoring is Oracle 12.1 RDS on AWS instance.

Message was edited by: Ben Alvey

mandevil · Answer

See my reply on your post under that specific custom report and see if that helps.

Custom Report - Top SQL by O/S User

rharland2012 · Answer

Customization of reports native to DPA seems very limited, so I haven't found a way to neatly do what you're after. I can drill down and associate a high-CPU wait to a user, but there's no tidy method I've yet found to tie user>cpu>wait. Perhaps other DPA users can shed some light on this. Good luck.