Re: TM Contention (locks type 2, 3, 6)
- From: Ls Cheng <exriscer@xxxxxxxxx>
- To: jonathan@xxxxxxxxxxxxxxxxxx
- Date: Tue, 28 Feb 2012 14:47:19 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » TM Contention (locks type 2, 3, 6)- LS Cheng
- » Re: TM Contention (locks type 2, 3, 6)- fairlie rego
- » Re: TM Contention (locks type 2, 3, 6)- Jonathan Lewis
- » Re: TM Contention (locks type 2, 3, 6) - Ls Cheng
- » Re: TM Contention (locks type 2, 3, 6)- Jonathan Lewis
- » Re: TM Contention (locks type 2, 3, 6)- Ls Cheng
- » Re: TM Contention (locks type 2, 3, 6)- Sidney Chen
- » Re: TM Contention (locks type 2, 3, 6)- Ls Cheng
- » Re: TM Contention (locks type 2, 3, 6)- Sidney Chen
- » Re: TM Contention (locks type 2, 3, 6)- Ls Cheng