Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!shaw.ca!news-out.superfeed.net!propagator2-maxim!news-in.superfeed.net!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews1.google.com!not-for-mail From: drak0nian@yahoo.com (Paul Drake) Newsgroups: comp.databases.oracle.server Subject: Re: space used by a user in a tablespace Date: 11 Nov 2003 16:24:03 -0800 Organization: http://groups.google.com Lines: 18 Message-ID: <1ac7c7b3.0311111624.62de4664@posting.google.com> References: NNTP-Posting-Host: 156.43.4.1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1068596644 15856 127.0.0.1 (12 Nov 2003 00:24:04 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 12 Nov 2003 00:24:04 +0000 (UTC) Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:247483 "Tom" wrote in message news:... > 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 Tom, the view dba_ts_quotas will show how much is allocated and used by each user for each tablespace on which they have a quota. Pd