Re: %USED, %FREE in TABLESPACES

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 Tue Sep 17 2002 - 19:11:39 CDT