Re: storing lobs as secure files - any gotchas?

From: orcl <>
Date: Wed, 27 Feb 2013 21:49:56 -0500
Message-ID: <>

 Thats excellent - thanks Tanel, Ill dig through that note and adjust accordingly
Tanel Poder wrote:
I recommend you read this too if you expect plenty of update activity on yoursecurefile 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 and 12c) you needto set _securefiles_concurrency_estimate = 50 before creating the tables.

Tanel Poder Enkitec (The Exadata Experts) Training[1] | Troubleshooting[2] | Exadata[3] | Voicee App[4]

Received on Thu Feb 28 2013 - 03:49:56 CET

Original text of this message