Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to list sizes of all tables?
Issue a dbms_utility command to analyze the entire schema, then select table_name,num_rows from user_tables. You could issue a num_rows*avg_row_size to get the table size (approx). Otherwise, you could use extents or segments (sum the bytes or blocks*blocksize in bytes) to get allocated size, or there's another dbms package to get space utilization. Can't remember off the top of my head though. Good luck.
"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message
news:92mhpi$7dm5g$1_at_ID-41926.news.dfncis.de...
> Dear all,
>
> I am trying to tune the performance of a database, I want to list the
sizes
> and number of rows of all tables for, say, a sepcific schema, does anyone
> know how to do it? Thanks in advance.
>
> Regards,
> Dino
>
>
>
Received on Mon Jan 01 2001 - 14:43:33 CST