Re: storing lobs as secure files - any gotchas?

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Thu, 28 Feb 2013 01:11:06 +0200
Message-ID: <CAMHX9JKGfa0DSzUfS92fO7Bh5pmKs0jB1LUDD=ftBxNUptO3Bg_at_mail.gmail.com>



Note that this is more of a bug, not a designflaw ... I would go with Securefiles as well on 11.2+
-- 
*Tanel Poder*
Enkitec (The Exadata Experts)
Training <http://blog.tanelpoder.com/seminar/> |
Troubleshooting<http://blog.tanelpoder.com/>
 | Exadata<http://www.amazon.com/Expert-Oracle-Exadata-Apress/dp/1430233923>
 | Voicee App <http://voic.ee/>



On Thu, Feb 28, 2013 at 1:10 AM, Tanel Poder <tanel_at_tanelpoder.com> wrote:


> I recommend you read this too if you expect plenty of update activity on
> your securefile LOB items:
>
> *Securefiles DMLs cause high 'buffer busy waits' & 'enq: TX - contention'
> wait events leading to whole database performance degradation [ID 1532311.1]
> *
> *
> *
> As a workaround (until the change gets built in to 11.2.0.4 and 12c) you
> need to set *_securefiles_concurrency_estimate = 50 **before* creating
> the tables.
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 28 2013 - 00:11:06 CET

Original text of this message