Re: space used by a user in a tablespace

"Tom" <tomNOSPAM_at_teameazyriders.com> a écrit dans le message de news:tZasb.829$bT1.5034150_at_news-text.cableinet.net...
> Hi,
>
> I need to find out the amount of space in actual MB, GB etc that a user is
> using. I know how to do this to determine the physical disk space a
> tablespace is taking up but is it possible to do the same but on a user by
> user level within a tablespace?
>
> This is on 8i and 9i on Solaris and Linux
>
> thanks
>
>

Something like:
select tablespace_name, owner, sum(bytes) from dba_segments
group by tablespace_name, owner;

Hope this helps
Michel Cadot Received on Tue Nov 11 2003 - 13:49:29 CST