Re: Space disk occupation ?

From: <mpir_at_compuserve.com>
Date: Fri, 31 Jul 1998 16:13:49 GMT
Message-ID: <6psqfu$oi4$1@nnrp1.dejanews.com>

Try 'select owner,tablespace,sum(bytes) from sys.dba_extents

      group by owner,tablespace
      order by owner,tablespace;'

It will list how much space every user has in each tablespace (including where they should not be.)

Enjoy.

In article <6pqk2a$6dg$1_at_pegase.production.axime.fr>,   "Patrick Marcouly" <patrick.marcouly_at_gsi.fr> wrote:
> Hi all,
>
> In my tablespace DATA I have 10 differents Users
>
> By the Oracle Toolbar I can see that the tablespace DATA have an allocation
> of 1Gb and 400Mb are used.
>
> But how can I know the allocation used by each user ?
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 31 1998 - 11:13:49 CDT