Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Locally Managed vs Dictionary managed tablespaces
One disadvantage of LMTS's I noticed: it is hard to predict the
space needed for the next extent of segments in such a tablespace.
The next_extent column in dba_segments is NULL (at least in V8.1.7 it is,
don't know about 9.0.1).
Monitoring this vital space requirement is much easier on DMTS's.
Anyone with a query that reports the free space deficit in LMTS's ?
Raymond.
Oracle DBA.
Received on Thu Nov 01 2001 - 14:19:54 CST