Re: Table Size????
From: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Mon, 3 Feb 2003 11:58:37 -0600
Message-ID: <i5y%9.41$gL1.30873_at_news.uswest.net>
Date: Mon, 3 Feb 2003 11:58:37 -0600
Message-ID: <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...Received on Mon Feb 03 2003 - 18:58:37 CET
> 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
>
>