Re: TM Contention (locks type 2, 3, 6)

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: "Oracle Mailinglist" <oracle-l@xxxxxxxxxxxxx>
  • 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.


Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com
Oracle Core (Apress 2011)
http://www.apress.com/9781430239543


----- Original Message ----- 
From: "Ls Cheng" <exriscer@xxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: "Oracle Mailinglist" <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, February 28, 2012 1:47 PM
Subject: Re: TM Contention (locks type 2, 3, 6)


| 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
|
|
|
| -----
| 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 

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2012