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" from dual) and show the output of current process utilization but the DS is not collecting data . It would be highly appreciated if anyone helps.

 

Regards,

Thangadurai G

  • Jon_Blake's avatar
    Jon_Blake
    Former Employee
    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