Technology Stack - EBS (MOSC)

MOSC Banner

Huge locks on fnd_profile_option_values.

edited Dec 15, 2013 11:37PM in Technology Stack - EBS (MOSC) 5 commentsAnswered
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

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