Re: Space management for Locally managed tablespaces

Hi Niall/Simon,

On 8.1.6 (don't ask) and 9.2 I get all the LMT stuff listed as well.

This may sound like another silly thing to suggest are we sure here that the LMT has any free space !!

Maybe metalink can shed some light ?

Cheers

Richard
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3e1ec155$0$245$ed9e5944_at_reading.news.pipex.net...
> 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
>
>
Received on Fri Jan 10 2003 - 08:27:10 CST