Re: determine size of table in KB ,inOracle DB

I don't know where my mind was on the original reply. I sais user_tables and what I meant was user_segments. You do not need to have the table analyzed to use user_segments and bytes is not on user_tables. Sorry for the red herring.

Terry Ball
Sr. DBA, CSG Systems

Jerry Gitomer wrote:

> 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 - 20:53:47 CEST