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:35:46 CST
