Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: size of user

Re: size of user

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 06 Jun 2002 21:17:48 GMT
Message-ID: <3CFFD173.9ABB00A1@exesolutions.com>


Sybrand Bakker wrote:

> "Uwe Wagner" <Uwe.Wagner_at_gef.de> wrote in message
> news:adksuk$dc0$1_at_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

I assumed he also wanted associated indexes, etc. but you are technically more correct given what he asked.

Daniel Morgan Received on Thu Jun 06 2002 - 16:17:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US