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

Home -> Community -> Usenet -> c.d.o.server -> Re: Tables Quota Usage - How?

Re: Tables Quota Usage - How?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 05 Sep 2002 20:52:10 +0200
Message-ID: <jt9fnu09198krmb34ek5l52u3mroacd9sl@4ax.com>

On 5 Sep 2002 09:18:20 -0700, emil_nikolov_at_hotmail.com (Emil Nikolov) wrote:

>Is there a way to find out what table is using what amount of space?
>I know how to get the total user quota usage, but if I can get it to a
>table level it would be much more helpful.
>
>Thanx.
>
>Emil Nikolov

select segment_name, bytes/1024 k
from user_|dba_segments

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Sep 05 2002 - 13:52:10 CDT

Original text of this message

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