OAAM: Queries to VCRYPT_TRACKER_USERNODE_LOGS are taking too long
Hello there
I am facing some performance issues with OAAM and we noticed the following query being run very frequently:
SELECT DISTINCT USER_IDFROM VCRYPT_TRACKER_USERNODE_LOGSWHERE NODE_ID= ?AND CREATE_TIME >= ?AND CREATE_TIME <= ?
The query also take a long time to be performed between 6 and 12 seconds to run the query.
The questions are:
1- What's the purpose of the query?
2- If they query is not required, is there a way to disable it?
3- If it is necessary to run the query, what options are there to improve performance of the system.
thanks for your help.
0