select * from v$temp_space_header;
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Raymond" <r_h_at_hetnet.nl> wrote in message
news:9rsabv$pe5$1_at_news1.xs4all.nl...
>
> 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 - 15:20:33 CST
