Re: space used by a user in a tablespace

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_at_spamdamenquery.com> wrote in message news:U7ydnahyRoUjASyiRVn-jw_at_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_at_yahoo.com> wrote in message
> news:1ac7c7b3.0311111624.62de4664_at_posting.google.com...
> > "Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message
> 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
> >
> > 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
>
>
Received on Tue Nov 11 2003 - 20:45:23 CST