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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Sanjay Mishra
Sent: Monday, February 24, 2020 5:19 PM
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
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.