The Oracle (tm) Users' Co-Operative FAQ

Should I migrate my dictionary managed tablespaces to locally managed tablespaces ?


Author's name: Jonathan Lewis

Author's Email: Jonathan@jlcomp.demon.co.uk

Date written: 2nd Nov 2001

Oracle version(s): n/a

Locally managed tablespaces appeared in Oracle 8, and offer a completely different way of handling extent management. Should I be migrating my database to locally managed tablespaces ?

Back to index of questions


This question is addressed by the following documents:

Author Title/URL Suggested by Referee's comments
Howard Rogers Which are better, Locally managed or Dictionary Managed tablespaces ? Jonathan Lewis A short pdf file with an intelligent discussion of the issues. You will need Adobe Acrobat to read this document.

NOTE - The referenced site was closed down by Oracle Australia. in May 2002. This link has been maintained in case Howards gets permission to re-open the site.

       

.


Further reading:


Back to top

Back to index of questions