Skip to Main Content
Spotfire Ideas Portal
Status To be Reviewed
Created by Guest
Created on Nov 26, 2019

We need a lib/util function to get the current sessionid / requestid of the session.

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. 

  • Attach files
  • Guest
    Nov 26, 2019

    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.