Re: 11.2 change in direct insert behavior

Okay, so I checked on 9.2.0.8

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


|

| Are you sure this is a change - as far as I can recall there has always

| been a TM mode 6 on "insert /*+ append */"

|

|

| -- 

| Regards

|

| Jonathan Lewis

| http://jonathanlewis.wordpress.com

| Oracle Core (Apress 2011)

| http://www.apress.com/9781430239543

|

|

| "Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message

| news:pan.2012.02.25.22.08.11_at_gmail.com...

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

||

|| http://docs.oracle.com/cd/E11882_01/server.112/e25494/

|| tables004.htm#i1009887

||

|| Let me quote:

|

|