Re: 11.2 change in direct insert behavior
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 25 Feb 2012 22:48:10 -0000
Message-ID: <P4Gdna1cd_qX-NTSnZ2dnUVZ8kydnZ2d_at_bt.com>
Date: Sat, 25 Feb 2012 22:48:10 -0000
Message-ID: <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...Received on Sat Feb 25 2012 - 16:48:10 CST
| 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: