Re: %USED, %FREE in TABLESPACES

Thanks Kevin (excuse my bad English),
Ok for the idea
SQL> INSERT INTO STATS SELECT TABLESPACE_NAME, sum(BYTES) FROM USER_EXTENTS GROUP BY TABLESPACE_NAME
/
How to get information about volume USED in the TS ? (insert it into STATS) (USER_EXTENTS, USER_SEGMENTS can help but I dont know how to. I make a desc for each of those tables and didnt see information about Volume USED). PS : for the day column I can insert sysdate. (I'm not dba)

Kevin Gillins a écrit :

> I have created my own repository. Briefly how I did it.
>
> 1) create a table to store stats in. Essentially a copy of DBA_TABLES with
> added columns for
> number_of_extents, size_in_bytes, date_of_sample
>
> 2) schedule a weekly database analyze.
>
> 3) After the analyze take a copy of the info from DBA_TABLES where stats
> have been stored.
>
> 4) Update the info with current extent info from DBA_SEGMENTS
>
> 5) After some time you can end up with some pretty good trends and
> information for your database.
>
> Kevin Gillins
>
> <cava123_at_noos.fr> wrote in message
> news:3d87a8e7$0$7454$79c14f64_at_nan-newsreader-03.noos.net...
> > 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)
> >
> > USER TS NAME SIZE USED FREE
> > ------- -------------- --------- -------- ---------
> > SCOTT DATA_1 200 MB 170 MB 30 MB
> > SCOTT INDEX_1 100 MB 60 40 MB
> >
> > Any help.
> > Thank You
> >
> > Yhab Abiad
> > yhab.abiad-sica_at_renault.com
> >
> >
> >
Received on Wed Sep 18 2002 - 15:30:29 CDT