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
Thangadurai
Posted 9 years ago·Last reply 9 years ago
1 comment
Jon_Blake
·9 years agoHi 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