Q
Manage Learn to apply best practices and optimize your operations.

Local or dictionary for tablespace management?

Which is better for tablespace management between local and dictionary?
Locally managed tablespaces are the way to go! I've been using them for a number of years now and I won't go back to dictionary managed tablespaces unless I have a really good reason to. In fact, Oracle agrees with this philosophy because future versions of Oracle will only have LMTs. There are simply too many benefits to LMTs not to use them, including automatically managing free and used extents, reduce bottleneck on data dictionary tables, free space won't become fragmented so as to be unusable, etc.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close