Dictionary Managed Tablespace vs Locally Managed Tablespace
Hello Experts,
What is the difference between Dictionary Managed and Locally Managed Tablespace?
Please assist me.
Thanks in advance.
Updated Jun 21, 2018
Hello Experts,
What is the difference between Dictionary Managed and Locally Managed Tablespace?
Please assist me.
Thanks in advance.
Comments
Locally managed table space came in picture to get rid of space transaction whenever there was need of space for next allocation of extent and independent of sys schema.
Let me explain in simple way:
When oracle allocates space to a segment like table or index, a group of contiguous blocks called extent is added to a segment .Metadata regarding extent allocation and unallocated extents are either stored in data dictionary or table space itself.
Table spaces that record extent in dictionary are called dictionary table spaces managed by sys schema as free space in sys.FET$ and used space in sys.UET$.
And whenever there is need of space transaction it has to depend on these.
Table spaces that record extents in the header of the data file these are called locally managed table space.whenever space is required they do not depend on any for used and free space as the table space itself manages it performance increases dictionary contention is reduced.