Path: news.easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!64.42.15.2!HSNX.atgi.net!newsfeed.media.kyoto-u.ac.jp!news-west.eli.net!not-for-mail
Message-ID: <3CFFC5C2.9961F2FF@exesolutions.com>
From: Daniel Morgan <dmorgan@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: size of user
References: <adksuk$dc0$1@cvs-server.gef.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 20
Date: Thu, 06 Jun 2002 20:27:56 GMT
NNTP-Posting-Host: 156.74.250.7
X-Complaints-To: yvonne.tracy@ci.seattle.wa.us
X-Trace: news-west.eli.net 1023395276 156.74.250.7 (Thu, 06 Jun 2002 14:27:56 MDT)
NNTP-Posting-Date: Thu, 06 Jun 2002 14:27:56 MDT
Organization: City of Seattle NewsReader Service
Xref: easynews comp.databases.oracle.misc:82594
X-Received-Date: Thu, 06 Jun 2002 13:25:20 MST (news.easynews.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