Re: How to find the exact SQL locking others?

I agree on the trigger...
sometimes the "before insert or update" trigger could be the root cause of
the enq row lock contention waits. I captured one instance by using
SQLTXPLAIN on the sql_id & it was able to show be the dependent
objects/procedures used on the SQL.
Peoplesoft even has this doc ID  Performance/Deadlock Issues Caused By
SYNCID Database Triggers [ID 1059120.1]



-- 
Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com


--
http://www.freelists.org/webpage/oracle-l

Other related posts: