Identity Management (MOSC)

MOSC Banner

OAAM: Queries to VCRYPT_TRACKER_USERNODE_LOGS are taking too long

edited Dec 10, 2012 3:05PM in Identity Management (MOSC) 4 commentsAnswered ✓
Hello there

I am facing some performance issues with OAAM and we noticed the following query being run very frequently:
SELECT DISTINCT USER_ID
FROM VCRYPT_TRACKER_USERNODE_LOGS
WHERE 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center