Re: TM Contention (locks type 2, 3, 6)
From: Ls Cheng <exriscer_at_gmail.com>
Date: Tue, 28 Feb 2012 14:47:19 +0100
Message-ID: <CAJ2-Qb-t3PG0QqLf6OiRN4iz8iGSe8TjJ426q6FppNsGJhr-0g_at_mail.gmail.com>
Hi
I did some tests and I noticed that if the table has FKs, insert append agaisnt it does not place mode 6 lock, instead it uses the normal mode 2 and 3 lock mode, is this a bug?
Date: Tue, 28 Feb 2012 14:47:19 +0100
Message-ID: <CAJ2-Qb-t3PG0QqLf6OiRN4iz8iGSe8TjJ426q6FppNsGJhr-0g_at_mail.gmail.com>
Hi
I did some tests and I noticed that if the table has FKs, insert append agaisnt it does not place mode 6 lock, instead it uses the normal mode 2 and 3 lock mode, is this a bug?
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 28 2012 - 07:47:19 CST