var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: update takes long time
oracel 18.104.22.168 aix
update statement is taking 3 minutes to update could you provide me steps to optimize this statement
update msg set assigntome= 774, status = 'In Progress', updat=sysdate where assigntome is null
and ticket= 'LP342765324' and companyid = 664
ANALYZE DATE 3-Nov-2006 1:02:07
TICKET - primary key
STATUS - NONUNIQUE
How does explain plan look like?
Something quite amiss here, if your stats are accurate - 3 minutes to update a table with 372 blocks seems awfully long.
Is your sql really that simple?
your statement might be locked while you are trying to perform update. maybe there was a previous statement that used the same table for update and hasnt been COMMIT yet.
previous statements don't suddenly get committed after 3 minutes (unless, of course, another session (as opposed to a statement) locked the table).