Hello,

You need this query :
SELECT table_name, num_rows, blocks, empty_blocks, avg_row_len, avg_space, FROM dba_tables
WHERE table_name = 'YOUR_TABLENAME' ;

If this query return no value, you need to compute statistics on your table( In my mind):
ANALYZE TABLE your_table COMPUTE STATISTICS ;

If you need the full size of your table, you can use this query :
SELECT segment_name "TABLE" , SUM(BYTES) /1024 || 'Ko' "Taille" , blocks "Blocs" , tablespace_name "TABLESPACE" FROM dba_segments
WHERE segment_type = 'TABLE'
AND segment_name = 'YOUR_TABLENAME'
GROUP BY segment_name, tablespace_name, blocks
ORDER BY segment_name
/

I hope this tips will help you.

Loïc MALASPINA,
Networks and systems engineer



-----Message d'origine-----
De : Lovie Buno [mailto:oracledba-ezmlmshield-x73278861.[Email address protected]
Envoyé : mercredi 29 mars 2006 09:36
À : LazyDBA Discussion
Objet : RE: How to get the table size based on Specific Records

Thank you Ram!

Do you have an existing script to do this? (sorry i'm just new in oracle...)

-----Original Message-----
From: Ram Sundar
[mailto:oracledba-ezmlmshield-x22036020.[Email address protected]
Sent: Wednesday, March 29, 2006 16:33
To: LazyDBA Discussion
Subject: Re: How to get the table size based on Specific Records


Hi

Use the avg_row_len from dba_tables to calulate the avg row size per group
of records
and you can then extrapolate it to size the table.

Thanks
Ram
----- Original Message -----
From: "Lovie Buno "
<oracledba-ezmlmshield-x44718488.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, March 29, 2006 1:43 PM
Subject: How to get the table size based on Specific Records


> Good day!
>
> Is there a fast way to get the size of an existing oracle table based on
> specific records?
> I have a table composed of 3 groups of records. Now, I want to identify
> the
> size of each group of data within the table. How to do??
>
> Thank you!
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page