Re: TM Contention (locks type 2, 3, 6)
Date: Tue, 28 Feb 2012 13:59:13 -0000
It's best to supply a short code example to make your meaning completely clear - but the answer to the question you probably asked is yes. The /*+ append */ hint cannot be honoured if there are enabled foreign key constraints in place.
- Original Message ----- From: "Ls Cheng" <exriscer_at_gmail.com> To: <jonathan_at_jlcomp.demon.co.uk> Cc: "Oracle Mailinglist" <oracle-l_at_freelists.org> Sent: Tuesday, February 28, 2012 1:47 PM Subject: Re: TM Contention (locks type 2, 3, 6)
| 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?
| No virus found in this message.
| Checked by AVG - www.avg.com
| Version: 2012.0.1913 / Virus Database: 2114/4836 - Release Date: 02/27/12