Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!elnk-pas-nf1!elnk-nf2-pas!newsfeed.earthlink.net!newshub.sdsu.edu!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail
NNTP-Posting-Date: Tue, 11 Nov 2003 20:46:22 -0600
From: "mcstock" <mcstockspamplug@spamdamenquery.com>
Newsgroups: comp.databases.oracle.server
References: <tZasb.829$bT1.5034150@news-text.cableinet.net> <1ac7c7b3.0311111624.62de4664@posting.google.com> <U7ydnahyRoUjASyiRVn-jw@comcast.com>
Subject: Re: space used by a user in a tablespace
Date: Tue, 11 Nov 2003 21:45:23 -0500
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: <78idnYhCx59jAyyiRVn-vw@comcast.com>
Lines: 45
NNTP-Posting-Host: 68.57.99.86
X-Trace: sv3-xJFGr7LvWjK3nYXcJ+Sk70TsAg0MjQWOOHVH4QxPEzSYv6tJ/dfJBuLPcCUqbdFhWV+c1YjxD12N6fq!HlmBwh8uR+gaQuauF0AKOKWo5ymfHpgC6SApUiAi8UlI+6sZ2M7K53SdeFw=
X-Complaints-To: abuse@comcast.net
X-DMCA-Complaints-To: dmca@comcast.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.1
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:247495

thanks to my aging dell, for generating a mouse click and sending this
message off before i was done...

anyway, keep in mind that oracle only tracks disk usage for object owners
(aka, schemas, accounts)

if you need to track disk usage by connected users for there
inserts/updates/sorts, that gets interesting.... hope that's not what you're
trying to do

"mcstock" <mcstockspamplug@spamdamenquery.com> wrote in message
news:U7ydnahyRoUjASyiRVn-jw@comcast.com...
> didn't see the rest of the thread, so don't know if this is covered,
but...
>
> keep in mind that oracle only tracks disk usage for
> "Paul Drake" <drak0nian@yahoo.com> wrote in message
> news:1ac7c7b3.0311111624.62de4664@posting.google.com...
> > "Tom" <tomNOSPAM@teameazyriders.com> wrote in message
> 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
> >
> > 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
>
>