Path: news.easynews.com!easynews!feedwest.aleron.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.misc
Subject: Re: size of user
Date: Thu, 6 Jun 2002 22:31:50 +0200
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <ufviru3ttsvkaf@corp.supernews.com>
Reply-To: "Sybrand Bakker" <postbus@sybrandb.-verwijderdit.demon.nl>
References: <adksuk$dc0$1@cvs-server.gef.de>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Complaints-To: newsabuse@supernews.com
Lines: 22
Xref: easynews comp.databases.oracle.misc:82597
X-Received-Date: Thu, 06 Jun 2002 13:49:39 MST (news.easynews.com)


"Uwe Wagner" <Uwe.Wagner@gef.de> wrote in message
news:adksuk$dc0$1@cvs-server.gef.de...
> 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) from user_segments where segment_type = 'TABLE'
or
select sum(bytes) from dba_tables where owner = '<yourowner>' and
segment_type = 'TABLE'
etc.

Hth