Re: size of user

From: Uwe Wagner <Uwe.Wagner_at_gef.de>
Date: Mon, 10 Jun 2002 08:48:21 +0200
Message-ID: <ae1i6d$1i3$1@cvs-server.gef.de>

Thanks a lot for your help.
This is exactly, what I need.

uwe

"Daniel Morgan" <dmorgan_at_exesolutions.com> schrieb im Newsbeitrag news:3CFFC5C2.9961F2FF_at_exesolutions.com...
> Uwe Wagner wrote:
>
> > Hi,
> >
> > I want to know the bytes used by all tables from one user.
> > Is this information available from a table or view ?
> >
> > uwe
>
> SELECT SUM(bytes)/1024/1024 MB_USED
> FROM user_segments;
>
> or
>
> SELECT SUM(bytes)/1024/1024 MB_USED
> FROM all_segments
> WHERE owner = <owner_name>;
>
> Daniel Morgan
>
Received on Mon Jun 10 2002 - 01:48:21 CDT