Re: determine size of table in KB ,inOracle DB
Date: Fri, 14 May 1999 11:19:59 -0400
Message-ID: <7hhepb$doi$1_at_autumn.news.rcn.net>
[Quoted] Hi Yaniv,
One other point, you have run ANALYZE on the table in question. If not user_tables will either contain an incorrect value or no value at all. If I remember correctly if you ESTIMATE STATISTICS on a very large table the row count is close but accurate. Our tables are small enough so that we can run ANALYZE COMPUTE STATISTICS on them every night so I don't recall the conditions under which I saw inaccurate answers.
regards
Jerry Gitomer
Terry Ball wrote in message <373B2F96.E458ECFF_at_csgsystems.com>...
>select bytes from user_tables where table_name = <yourtablename>
>and in KB
>select bytes/1024 from user_tables where table_name = <yourtablename>
>
>
>Terry Ball
>Sr. DBA, CSG Systems
>
>Yaniv wrote:
>
>> how can I determine the size of table in my Oracle DB ?
>> Thanks.
>
Received on Fri May 14 1999 - 17:19:59 CEST