Re: Gathering Information

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 27 Sep 1999 19:07:25 +0200
Message-ID: <938452127.5851.0.pluto.d4ee154e@news.demon.nl>

Here is a small example

select b.tablespace_name

     , trunc(a.sumused/(1024*1024)) "M allocated"
     , trunc(b.sumfree/(1024*1024)) "M free"
     , f.sumall/(1024*1024)        "M available"

from
(select tablespace_name, sum(bytes) sumused  from dba_segments
 group by tablespace_name) a,
(select tablespace_name, sum(bytes) sumfree  from dba_free_space
 group by tablespace_name) b,
(select tablespace_name, sum(bytes) sumall  from dba_data_files
 group by tablespace_name) f
where a.tablespace_name(+) = b.tablespace_name and f.tablespace_name = b.tablespace_name /

Hth,

--
Sybrand Bakker, Oracle DBA
<amerar_at_ci.chi.il.us> wrote in message news:7so5hs$h3t$1_at_nnrp1.deja.com...
>
>
> Hello,
>
> We are about to move our database to a new machine. Before doing so, we
> have decided to re-create the filesystems so they can handle the
> database for the next 2 years. At the same time, I may increase some of
> the tablespace sizes.
>
> I am looking to create a query that will show me by tablespace/table the
> current storage allocation and important parameters.......I'm not sure
> how I should approach this.
>
> Any suggestions?
>
> Thanks,
>
> Arthur
> amerar_at_ci.chi.il.us
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Sep 27 1999 - 12:07:25 CDT