Re: 11.2 change in direct insert behavior

From: Jonathan Lewis <>
Date: Sat, 25 Feb 2012 22:48:10 -0000
Message-ID: <>

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" <> 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:
| tables004.htm#i1009887
| Let me quote:
Received on Sat Feb 25 2012 - 16:48:10 CST

Original text of this message