we upgraded Clarity on production environment of our customer and we are now facing problem with performance of DB server, which is overloaded with requests from Clarity. The exact request which is generated to overload the database is:
SELECT COUNT (1) FROM CMN_SEC_CHK_USER_INST_V0 WHERE USER_ID = :B4 AND
OBJECT_ID = :B3 AND PERMISSION_CODE = :B2 AND OBJECT_INSTANCE_ID = :B1
AND ROWNUM = 1
We upgraded test environment (binary copies of production environment) twice, before we upgraded the production environment, but we did not faced this issue. Strange is that the test environment is not as efficient as production so hardware is not the problem.
Is it possible to find out which process or function of Clarity is generating the request I mentioned above?
We will be gratefull if you can help us by some assumptions or recommendation.
The exact Clarity version is 22.214.171.1242.