Re: Current Tables' Size
From: Eric Givler <egivler_at_flash.net>
Date: Sun, 03 Dec 2000 04:01:41 GMT
Message-ID: <FAjW5.25790$6W1.1433988_at_news.flash.net>
Date: Sun, 03 Dec 2000 04:01:41 GMT
Message-ID: <FAjW5.25790$6W1.1433988_at_news.flash.net>
This will require an analyze on the table.
"Lee" <lstrode_at_TAMPABAY.RR.COM> wrote in message
news: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
[Quoted]
> news:3A1B848E.25E76863_at_hket.com...
> > How can I check the current tables' size. Thank you.
> >
> >
>
>
Received on Sun Dec 03 2000 - 05:01:41 CET