We can use this utility to find out who has consumed more resources from the sys_requests table. We can create a cache table based out of sys_requests to persist the information. We can join the session_id we got from the utility and find out the history of the SQL's executed.
We are using tableau application with Tibco DV. There are several requests coming in from tableau to DV. However, we are unable to find out which user is the top memory / CPU consumer. Using this new utility we can log the username/ sessionid in the logs and then cache the sys_requests table. This will help us to identify the top resource consumers.