Re: storing lobs as secure files - any gotchas?
From: orcl <orcl_at_comcast.net>
Date: Wed, 27 Feb 2013 21:49:56 -0500
Message-ID: <512EC5D4.6000800_at_comcast.net>
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:
Date: Wed, 27 Feb 2013 21:49:56 -0500
Message-ID: <512EC5D4.6000800_at_comcast.net>
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 11.2.0.4 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]
- "Oracle error messages being what they are, do not highlight the correct cause of fault, but will identify some other error located close to where thereal fault lies."