shekar2130

 Profile Answers by shekar2130 

• Jul 17th, 2010

 

We can manage table space in 2 ways, they are:
1. Locally managed
2. Dictionary managed
From 10g LMTS is default, DMTS is manual
Upto 9i DMTS is default, LMTS is manual
The difference between LMTS,DMTS is in LMTS freespace avilable in datafile header etc can be checked by Oracle defaultly, whereas in DMTS it can be checked by user so automatically it will degrades the performance.

ashdba

 Profile Answers by ashdba 

• Sep 5th, 2010

 

Tablespace can be managed by specifying Extent management local or Extent management dictionary, segment space management auto or manually by using the key words pctfree, pctused, pctincrease during tablepsace creation.

Affrayam

• Mar 8th, 2013

 

The difference between LMTS & DMTS is if the extent management is local(LMTS) the information about free extents and free blocks will be maintained in DATAFILE HEADER it self AND if the extent management is dictionary(DMTS)
the information about free extents and free blocks will be maintained in DATA DICTIONARY so internally oracle issues a select statement on DATA DICTIONARY(SYSTEM) in the case of DMTS.