Re: Space management for Locally managed tablespaces

Hmm

on 8173 I get

SQL> ed
Wrote file afiedt.buf

  1 select s.tablespace_name,round(sum(s.bytes/(1024*1024*1024)),2) free_space_GB
  2 from dba_free_space s,dba_tablespaces t   3 where s.tablespace_name=t.tablespace_name   4 and t.extent_management='LOCAL'
  5* GROUP BY s.tablespace_name
SQL> /

TABLESPACE_NAME                FREE_SPACE_GB
------------------------------ -------------
AGRCOMPELLO                             1.99
AGRHISTR                                3.94
AGRHISTR4                               2.07
AGRINDEX                                1.66
AGRINDEX4                                2.2
AGRSTATIC                               3.86
AGRSTATIC4                               2.7
AGRTEMP                                 3.27
AGRTRANS                                3.86
AGRTRANS4                               1.29
LOB_DATA                                1.14
RBS                                     1.58
TOOLS                                    .23

13 rows selected.

The only thing that I can think *might* be different is that all of the above use uniform extent allocation, do your tablespaces use automatic extent allocation? I get a similar result on 9.2

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Simon Lenn" <simonlenn_at_yahoo.com> wrote in message
news:3641e2c2.0301100425.1abfdba5_at_posting.google.com...


> Hi Richard

>

> But I cannot see free space and space used from DBA_SEGMENTS and

> DBA_FREESPACE for LMTS I can see for DMTS but not for LMTS that was

> why I raised the question.

>

> Thanks

> Simon

> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message

news:<OkuT9.20359$jM5.56173_at_newsfeeds.bigpond.com>...


> > Hi Simon,

> >

> > Forgive me if I've misunderstood the question ...

> >

> > Where to find free space => DBA_FREE_SPACE

> >

> > Where to find what has used what tablespace => DBA_SEGMENTS /

DBA_EXTENTS


> >

> > But I'm not if this is what you're after ?

> >

> > Cheers

> >

> > Richard

> > "Simon Lenn" <simonlenn_at_yahoo.com> wrote in message

> > news:3641e2c2.0301091648.7e882ec7_at_posting.google.com...

> > > hello all

> > >

> > > We use Oracle 9i as part of an application we are running the

> > > application vendor is asking us to convert all our tablespaces to

> > > Locally managed tablespaces. In oracle 8i once a tablespace was set to

> > > locally managed there was no way of getting to know the free and used

> > > space on the locally managed tablespace (put it this way I do not know

> > > of a method to find free and used space for a locally managed

> > > tablespace). How can we find the space usage for a locally managed

> > > tablespace.

> > >

> > > Thanks

> > > Simon