Re: Gathering Information

Hi

You should analyze the DB with analyze command.This will fill some tables. look into these
DBA_TABLES, DBA_SEGMENTS, DBA_FREE_SPACE, DBA_INDEXES also you can use some Oracle tools such as Storage Manager, Tablespace Manager

I hope this will help

feherl

amerar_at_ci.chi.il.us wrote:

> 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 - 16:22:55 CDT