Re: TM Contention (locks type 2, 3, 6)
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Sun, 4 Mar 2012 00:10:49 +0800
Message-ID: <CAM_ddu852MVwokCt1SDsNwXxLAoDYW7BmzHBK-J8SZ15wdwneQ_at_mail.gmail.com>
If you check sid for the blocked session which request mode is 6, and check the v$session.sql_id, you should get the sql attempting the acquire the TM lock in mode 6.
Have you check the status for the FK, if it's disabled, direct path insert will be still honored.
Date: Sun, 4 Mar 2012 00:10:49 +0800
Message-ID: <CAM_ddu852MVwokCt1SDsNwXxLAoDYW7BmzHBK-J8SZ15wdwneQ_at_mail.gmail.com>
If you check sid for the blocked session which request mode is 6, and check the v$session.sql_id, you should get the sql attempting the acquire the TM lock in mode 6.
Have you check the status for the FK, if it's disabled, direct path insert will be still honored.
--
Regards
Sidney Chen
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Mar 03 2012 - 10:10:49 CST