AnsweredAssumed Answered

row lock contention

Question asked by effjott on Jun 4, 2008
Latest reply on Oct 11, 2012 by loglady
Hi all,

we just have Alfresco installed on Oracle 10.2.0.2

on several point we got "TX row lock contention"

One causing sql is
update alf_node set version=:1, protocol=:2, identifier=:3, uuid=:4, type_qname=:5, acl_id=:6 where id=:7 and version=:8

another is
delete from alf_child_assoc where id=:1 and version=:2

Does someone out there have simular problems ?

"row lock contention" occurs is 2 or more sessions want to update the same record, but the first session didn't send a commit.

br
EffJott

Outcomes