How to find the current sizes of the tables in a Database?

Priya dharshini

Ranch Hand

Posts: 78

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,
How to find the current sizes of the tables in a Database. Please any one help me out.

Thanks & Regards,
Priyadharshini . T

Agador Paloi

Ranch Hand

Posts: 118

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

checkout Dan Morgans Library page from Puget sound Oracle Users Group on tables:
http://www.psoug.org/reference/tables.html

check out the two queries at the bottom of the page. Excellent resource

Ulf Dittmer

Rancher

Posts: 43081

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Do you mean the number of rows, or something that is measured in KB/MB/GB? If the former, "select count(*) from table" will tell you that.
[ September 27, 2007: Message edited by: Ulf Dittmer ]

Paul Campbell

Ranch Hand

Posts: 338

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

If you want to know the number of rows in a table:

SELECT num_rows
FROM all_tables
WHERE table_name = 'YOUR_TABLE_NAME'

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?