Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: size of user
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