Re: space used by a user in a tablespace

From: Michel Cadot <micadot2removethat_at_free.fr>
Date: Wed, 12 Nov 2003 16:23:22 +0100
Message-ID: <3fb25045$0$261$636a55ce@news.free.fr>

"Paul Drake" <drak0nian_at_yahoo.com> a écrit dans le message de news:1ac7c7b3.0311120702.a26c480_at_posting.google.com... > "Michel Cadot" <micadot2removethat_at_free.fr> wrote in message news:<3fb1d728$0$231$636a55ce_at_news.free.fr>...
> > "Paul Drake" <drak0nian_at_yahoo.com> a écrit dans le message de
> > 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

> >

> > dba_ts_quotas contains data only for users with quotas,
> > so users with "unlimited tablespace" privilege are not in this view
> > (unless you give them some quotas which are not taken into account by Oracle).

> >

> > Michel Cadot

>
> Michel,
>
> "on which they have a quota" (see above) was clear to me, guess that I
> should have been more verbose. we are not in disagreement.
>
> your users have the privilege unlimited tablespace?
> (either directly, or via a role).
> I thought that went out the door at most places when they moved off of
> Oracle 7.3.4.
>
> Paul

Sorry Paul, i misread your answer or more exactly i read it with Tom's original question in mind which is more general. So we are not in disagreement.

BTW, "unlimited tablespace" cannot be granted via a role except "resource" or "dba" but they are not fair roles. :) They are still there for compatibity with the old privileges from Oracle v6 and because many non-Oracle softwares cannot say what real privileges they need and they prefer to ask for "resource" or even "dba". :(

Regards
Michel Cadot Received on Wed Nov 12 2003 - 09:23:22 CST