This content has been marked as final. Show 5 replies
Are you using secure file LOBs?
Out of curiosity, when you made the 3 changes you listed did you make them one at a time and test each change individually? In other words, was there a continued improvement as you made each changes or did one of the changes give you the biggest improvement?
We investigated and found that below changes to resolve the issue that gave better performance.
1) db_block_size = to be changed from 8K to 16K
2) intial and next extent size to be changed to 100M
3) segment_space_management to be changed from Auto to Manual
Instead global space management, did you try to set just LOB storage parameters, like ALLOCATE EXTENT, CHUNK, DEDUPLICATE, COMPRESS?
As i am new to Oracle DB, not able to check with parameters like ALLOCATE EXTENT, CHUNK, DEDUPLICATE, COMPRESS?
I would give you the same answer as I did in your duplicate thread: BLOB inserts performance slow when segment space management is Auto
If you don't, already, cache the LOBS. This will likely give you the biggest bang for the buck and make LOB DML much much faster. Just be advised that this will consume some of your SGA.
alter table t modify lob( lob_col ) ( cache );