Re: Current Tables' Size
From: Lee <lstrode_at_TAMPABAY.RR.COM>
Date: Wed, 22 Nov 2000 10:45:19 GMT
Message-ID: <3tNS5.55830$vc3.10785011_at_typhoon.tampabay.rr.com>
Date: Wed, 22 Nov 2000 10:45:19 GMT
Message-ID: <3tNS5.55830$vc3.10785011_at_typhoon.tampabay.rr.com>
One method is:
select ((num_rows*avg_row_length)/1024/1024) as "Approx Size in MB"
from all_tables
where table_name = &TBL_NAME.;
This is an appoximate, not sure how to do this for indexes though.
"Rayfil Cheung" <rayfilcheung_at_hket.com> wrote in message
news:3A1B848E.25E76863_at_hket.com...
> How can I check the current tables' size. Thank you.
>
>
Received on Wed Nov 22 2000 - 11:45:19 CET