RE: [EXTERNAL] Oracle Securefile Lobs

I dealt with this situation recently. I even tried reorganizing LOBs but no avail. In the end I’d to sought help from oracle support who dived in and suggested few internal memory parameters to be set and then reorganize LOBs once again. It has helped somewhat but to what extent is still too early to call.

alter system set "_enable_space_preallocation= 3;

alter system set "_ktslj_segext_warning" = 0;

alter system set "_securefiles_concurrency_estimate"=50 scope=spfile;

HTH. Thanks.

-Saad

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: Monday, February 24, 2020 5:19 PM To: Oracle-L Freelists <oracle-l_at_freelists.org> Subject: [EXTERNAL] Oracle Securefile Lobs

External Email. Use Caution.
I had one application that stores lots of transactional data in LOB and the same is updated heavily. Does frequent update on LOB

1. Impact system performance heavily
2. Can cause lots of Fragmentation
3. Need any frequent maintenance as part of optimization

The database is 18c and LOBS are secure files and Partitioned.

TIA
Sanjay

The information contained in this electronic e-mail transmission and any attachments are intended only for the use of the individual or entity to whom or to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this communication is not the intended recipient, or the employee or agent responsible for delivering this communication to the intended recipient, you are hereby notified that any dissemination, distribution, copying or disclosure of this communication and any attachment is strictly prohibited. If you have received this transmission in error, please notify the sender immediately by telephone and electronic mail, and delete the original communication and any attachment from any computer, server or other electronic recording or storage device or medium. Receipt by anyone other than the intended recipient is not a waiver of any attorney-client, physician-patient or other privilege.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 25 2020 - 18:04:18 CET