Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Can Locally managed Tablespace helpful?

Occasional Advisor

Can Locally managed Tablespace helpful?

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
Honored Contributor

Re: Can Locally managed Tablespace helpful?


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.

Only by ignoring what everyone think is important, can you be aware of what everyone ignores!