Tablespace for LOB's

[jnrpeardba]

Hi Tim,

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

Jnrpeardba

[Tim...]

Hi.

This should explain.

http://www.oracle-base.com/articles/11g ... -11gr1.php

Cheers

Tim...

[jnrpeardba]

Thanks Tim,

that doc is really helpful

Jnrpeardba

[Tim...]