Re: SQL : informations about occupied data/index

[Quoted] request USER_SEGMENTS dont much informations about data USED sql> select * from user_segments where segment_name = 'DEPT'; ==> 10 240 Blocks
sql> select count(*) from dept ;

   ==> 4
and the average size of data in DEPT is : sql> analyze table DEPT compute statistics ; sql> select avg_row_len * num_rows ||' bytes ' from user_tables where table_name='DEPT' ;
==> 92 bytes

SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME BLOCKS EXTENTS FREELISTS

-------------------- ----------------- -------------------- ---------

DEPT                 TABLE             USER_DATA                10240         1         1

that is mean
Daniel Morgan a écrit :

> cava123 wrote:
>
> > Hi all,
> > I create a table T_STATS (with User SCOTT) and want to store
> > informations about occupied data/index in TS like this :
> >
> > USER TS NAME SIZE (MB) USED FREE
> > STATS_DATE
> > ------- -------------- --------- ----------
> > ------- --------------
> > SCOTT DATA_1 200 MB 50 MB 150 MB
> > 24/04/2000
> > SCOTT INDEX_1 100 MB 40 MB 60 MB
> > 24/04/2000
> > SCOTT DATA_1 200 MB 100 MB 50 MB
> > 24/04/2001
> > SCOTT INDEX_1 100 MB 60 MB 40 MB
> > 24/04/2001
> > SCOTT DATA_1 200 MB 170 MB 30 MB
> > 24/04/2002
> > SCOTT INDEX_1 100 MB 60 MB 40 MB
> > 24/04/2002
> >
> > Someting look like :
> > INSERT INTO SCOTT.T_STATS VALUES (SELECT .............., sysdate from
> > xxx where ....) ;
> >
> > I dont know how to write the request.
> > Thanks for help.
> > I'm simple user in the database and have no grants for dba_% or V$%,
> >
> > Yhab
> > yhab.abiad-sica_at_renault.com
>
> We don't do other people's homework assignments for them. Do your
> research work and then we will give you pointers.
>
> Your pointer d'jour is:
>
> SQL> desc user_segments
>
> Daniel Morgan
Received on Sun Sep 22 2002 - 02:18:48 CEST