Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.linkpendium.com!news2.telebyte.nl!news.cambrium.nl!news.cambrium.nl!news.cambrium.nl!amsnews01.chello.com!news-hub.cableinet.net!blueyonder!internal-news-hub.cableinet.net!news-text.cableinet.net.POSTED!53ab2750!not-for-mail
From: "Tom" <tomNOSPAM@teameazyriders.com>
Newsgroups: comp.databases.oracle.server
Subject: space used by a user in a tablespace
Lines: 12
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
Message-ID: <tZasb.829$bT1.5034150@news-text.cableinet.net>
Date: Tue, 11 Nov 2003 19:43:21 GMT
NNTP-Posting-Host: 82.43.193.93
X-Complaints-To: abuse@blueyonder.co.uk
X-Trace: news-text.cableinet.net 1068579801 82.43.193.93 (Tue, 11 Nov 2003 19:43:21 GMT)
NNTP-Posting-Date: Tue, 11 Nov 2003 19:43:21 GMT
Organization: blueyonder (post doesn't reflect views of blueyonder)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:247458

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


