Re: How to find the exact SQL locking others?
From: Karl Arao <karlarao_at_gmail.com>
Date: Mon, 2 Jul 2012 11:13:56 -0500
Message-ID: <CACNsJndX_HMEGRuHtBoGXeY7PXBs6sYvwmmvBJ_FXVZ5rD3+RQ_at_mail.gmail.com>
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]
Date: Mon, 2 Jul 2012 11:13:56 -0500
Message-ID: <CACNsJndX_HMEGRuHtBoGXeY7PXBs6sYvwmmvBJ_FXVZ5rD3+RQ_at_mail.gmail.com>
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
Received on Mon Jul 02 2012 - 11:13:56 CDT