Re: SECUREFILES disaster

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 27 Apr 2012 20:57:51 +0100
Message-ID: <NYadnTzG9f6aZwfSnZ2dnUVZ8lWdnZ2d_at_bt.com>


"Mladen Gogala" <gogala.mladen_at_gmail.com> wrote in message news:pan.2012.04.22.19.20.39_at_gmail.com...
| effectively transform row level locking into table level locking, with
| predictably disastrous effects on concurrency.

More like extent-level locking - and then only with the concurrency impact of buffer busy waits, not table locks.
I've seen some undesirable effects with LOBs that can't be worked around, but nothing catastrophic (yet).

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com
Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
Received on Fri Apr 27 2012 - 14:57:51 CDT

Original text of this message