I have been asked to look into the improvement of LOBs on our system. However I have question after reading a number of pages and posts
I will set up a new tablespace and move the LOB tables and segments into this tablespace
Many of the settings for improvement are: block size , chunk size, disable storage, nocache, compress and DEDUPLICATE.
I have found that I can create the tablespace with the default compress and blocksize but unsure where I set the other settings. Do I alter the LOB's to have nocache, deduplicate and chunk size or the tablespace?
I am aware that I can do the following:
- Code: Select all
create tablespace lob_tbs datafile '/oradata/testdb/lob_tbs.dbf' size 500M default compress BLOCKSIZE 32k;
Many thanks if you can assist in any way