Huge locks on fnd_profile_option_values.
Dear
from the last 15 days we are observing huge lock on the table fnd_profile_option_values. below is the query get fired
SELECT HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_ID = :B2 AND APPLICATION_ID = :B1
---------------
DELETE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B5 AND APPLICATION_ID = :B4 AND LEVEL_ID = :B3 AND LEVEL_VALUE = :B2 AND (NVL(:B1 , -1) = -1 OR LEVEL_VALUE_APPLICATION_ID = :B1 )
Thanks and Regards
from the last 15 days we are observing huge lock on the table fnd_profile_option_values. below is the query get fired
SELECT HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_ID = :B2 AND APPLICATION_ID = :B1
---------------
DELETE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B5 AND APPLICATION_ID = :B4 AND LEVEL_ID = :B3 AND LEVEL_VALUE = :B2 AND (NVL(:B1 , -1) = -1 OR LEVEL_VALUE_APPLICATION_ID = :B1 )
Thanks and Regards
Tagged:
0