Forum Discussion

Thangadurai's avatar
Thangadurai
8 years ago

Oracle DB SQL query monitor for process utilization

Dear All, I have created a DS which executes the SQL query (ie,  select ((select count(*) from v$process)/(select value from v$parameter where name='processes')*100) as "CURRENT_UTILIZATION" ...
Jon_Blake's avatar
Jon_Blake
8 years ago

Hi Thangadurai, 

We have an example datasource that will provide the current/max process and session utilization our LM Exchange area a href="https://communities.logicmonitor.com/topic/1144-oracle-process-and-session-utilization/" rel="">here

Hopefully that solves this for you.  

Regards,

-Jon