Forum Discussion

Thangadurai's avatar
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.



Thangadurai G

1 Reply

Replies have been turned off for this discussion
  • Hi Thangadurai, 

    We have an example datasource that will provide the current/max process and session utilization our LM Exchange area a href="" rel="">here

    Hopefully that solves this for you.