Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!news.webusenet.com!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!diablo.theplanet.net!mephistopheles.news.clara.net!news.clara.net!proxad.net!feeder2-1.proxad.net!news3-2.free.fr!not-for-mail
From: "Michel Cadot" <micadot2removethat@free.fr>
Newsgroups: comp.databases.oracle.server
References: <tZasb.829$bT1.5034150@news-text.cableinet.net>
Subject: Re: space used by a user in a tablespace
Date: Tue, 11 Nov 2003 20:49:29 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Lines: 25
Message-ID: <3fb13d2c$0$13269$626a54ce@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 11 Nov 2003 20:49:01 MET
NNTP-Posting-Host: 82.67.171.166
X-Trace: 1068580141 news3-2.free.fr 13269 82.67.171.166:2043
X-Complaints-To: abuse@proxad.net
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:247460


"Tom" <tomNOSPAM@teameazyriders.com> a écrit dans le message de
news:tZasb.829$bT1.5034150@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