Re: How to find the exact SQL locking others?
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Mon, 2 Jul 2012 11:13:56 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
