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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 6 Jun 2002 22:31:50 +0200
Message-ID: <ufviru3ttsvkaf@corp.supernews.com> 






"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
Received on Thu Jun 06 2002 - 15:31:50 CDT












Original text of this message













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