Rajini

update statement taking too long to execute

Discussion created by Rajini on Feb 16, 2011
Latest reply on Feb 17, 2011 by Rajini
We have a daily feed of OBS data into Clarity via XOG. The below statement as a result of XOG activity is taking long time about 2 minutes sometimes. When we remove the is_security=1 update in the statement, the command runs much faster.

UPDATE prj_obs_types
SET is_security = 1 ,
last_updated_by = *** ,
last_updated_date = ***
WHERE id = 5000025

The explain plan shows the index update for CMN_SEC_USERS_V is consuming upto 40% of cost.

Any ideas/suggestions?

Outcomes