Can Locally managed Tablespace helpful?

[xiongye_2]

Hi: If I use locally managed tablespace, do I still need scheme every table stroage parameter? Can it archive performance acceleration ? Thanks !!

[Andreas D. Skjervold]

Hi

Localy managed tablespaces stores the dictionary information in the tablespace itself (as structures in the datafiles), in opposite to in the Data Dictionary that is located in the system tablespace.

This function was put in place to be able to transport tablespaces between systems for data distribution.

That is you can create a Read only tablespace that is managed locally, and place its files on a CD to be shipped to your other locations. Good for product catalog etc.

What this means for performance?
It takes some of the work away from the system tablespace, but this is seldom a bottleneck anyway.

Another nice feature with it is the uniform storage clause. Using this you can aviod fragmentation of your tablespace as all data are stored in equally sized pieces. Just be sure to size the pices properly or you end up wasting space.


Andreas