Re: 11.2 change in direct insert behavior
Date: Sat, 25 Feb 2012 22:53:55 -0000
Okay, so I checked on 220.127.116.11
create table t3 as select * from t1 where rownum <= 0; insert /*+ append */ into t3 select * from t1 where rownum <= 10000; select * from v$lock;
Showed TM/6 on t3 - so that's not a change introduced by 11g.
I haven't checked the effects on a partitioned table - I have a vague memory that the exact behaviour may depend on whether the insert uses explicit partition naming: maybe there's been some change in behaviour there.
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Oracle Core (Apress 2011) http://www.apress.com/9781430239543 "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:P4Gdna1cd_qX-NTSnZ2dnUVZ8kydnZ2d_at_bt.com...Received on Sat Feb 25 2012 - 16:53:55 CST
| Are you sure this is a change - as far as I can recall there has always
| been a TM mode 6 on "insert /*+ append */"
| Jonathan Lewis
| Oracle Core (Apress 2011)
| "Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message
|| This is about a surprising conclusion of a debate from Oracle Support
|| Community forums. Somebody has complained about "being locked on the
|| table". I checked the attached diagnostic output and found a lock with
|| lock type TM and locking mode 6 and looked no further as it is an
|| exclusive table lock. I dismissed the case as a work of an application
|| designer who should be, in my own words, "hanged, drawn and quartered as
|| an example to the others". Boy, was I wrong!
|| It turned out that there was a slight behavior change in the Oracle 11:
|| Let me quote: