Re: storing lobs as secure files - any gotchas?
- From: Tanel Poder <tanel@xxxxxxxxxxxxxx>
- To: orcl@xxxxxxxxxxx
- Date: Thu, 28 Feb 2013 01:11:06 +0200
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@xxxxxxxxxxxxxx> 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.
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
