we are planning to replace the external terracotta cache(BigMemory) with internal terracotta cache.
we are trying to find out most used cache service and need to do the POC on it’s associated flow. I fired the below query to list out the execution count for each service on WMSERVICE table.
select SERVICENAME,COUNT(*) as COUNT1 from WMSERVICE Group by SERVICENAME
ORDER BY COUNT1 DESC;
It’s gives the result only for the top level service. I want to see the execution count for each and every service. Can anyone have any idea?
Thanks in Advance!