Re: Table Size????

FYI - in this query, the table name should have been dba_extents, not dba_segments. Somebody else posted nearly the same query against dba_segments, but that query (as they correctly showed) does not need to SUM() the bytes.

Chris

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW

"Chris Leonard" <s_p_a_m_chris_at_hotmail.com> wrote in message news:i5y%9.41$gL1.30873_at_news.uswest.net...
> Hi Josh,
>
> You might want to try a query like this one, which will sum up the size of
> all extents allocated to a segment (such as the table SCOTT.EMP in this
> example). Of course, you'll need to plug in appropriate values instead of
> OWNER and SEGMENT_NAME ...
>
> select sum (bytes)
> from dba_segments
> where owner = 'SCOTT'
> and segment_name = 'EMP'
>
> --
> Cheers,
> Chris
>
> ___________________________________
>
> Chris Leonard, The Database Guy
> http://www.databaseguy.com
>
> Brainbench MVP for Oracle Admin
> http://www.brainbench.com
>
> MCSE, MCDBA, OCP, CIW
> ___________________________________
>
> "Joshua Wolfe" <jwolfe_at_trigonium.com> wrote in message
> news:aVx%9.3741568$6N5.489581_at_post-03.news.easynews.com...
> > Ok, I know this is probably a stupid question, but how can I find out
 how
> > much space on disk any given table is using? I am running Oracle 8.1.7
 if
> > that helps. Thanks.
> >
> > Josh
> >
> >
>
>
Received on Tue Feb 04 2003 - 05:41:33 CET