Re: Iformation about ocupied data in the database

Excuse my bad English Daniel.
I create a table scott.stats and want to store informations like this :

USER          TS NAME         SIZE            USED         FREE         D
-------           --------------      ---------         --------
---------       ----
SCOTT          DATA_1        200 MB        50 MB      150 MB         24/04/2000
SCOTT          INDEX_1        100 MB       40              60 MB
24/04/2000
SCOTT          DATA_1        200 MB        100 MB      50 MB         24/04/2001
SCOTT          INDEX_1        100 MB       60               40 MB
24/04/2001
SCOTT          DATA_1        200 MB        170 MB      30 MB         24/04/2002
SCOTT          INDEX_1        100 MB       60               40 MB

So, I know that scott data grow +50 MB the first year, and 70 MB the second year and so on.
(USER_SEGMENTS, USER_FREE_SPACE, USER_EXTENTS can help me I dont know which column to use...)

Yhab
Daniel Morgan a écrit :

> cava123_at_noos.fr wrote:
>
> > Hi all,
> > I need informations about the volume of data in my base and how the data are
> > distributed in their assigned space
> > (I mean only users data not system, sys)
> > Suppose that I have DATA_1 (default TS for user scott tables) and INDEX_1
> > (tablespace which scott create indexes).
> >
> > The purpose is to know how data is grow up in the database : For know I need
> > to extract the informations in day 1 and apply the same sql script for (day
> > + 15)
> > Any help please
> > Thank You
> >
> > Yhab Abiad
> > yhab.abiad-sica_at_renault.com
>
> SELECT table_name, column_name
> FROM dba_tab_columns
> WHERE column_name LIKE '%EXTENT%'
> OR column_name LIKE '%BLOCK%'
> OR column_name LIKE '%SEGMENT%'
> OR column_name LIKE '%FILE%';
>
> You will find what you need to proceed here. This is obviously a class project
> and you should figure out the details on your own.
>
> Daniel Morgan
Received on Wed Sep 18 2002 - 23:37:26 CEST