Re: Schema Disk Size

From: gazzag <gareth_at_jamms.org>
Date: Mon, 11 Jun 2007 08:04:00 -0700
Message-ID: <1181574240.693375.48050@p77g2000hsh.googlegroups.com>

On 11 Jun, 15:40, "Jean-Luc" <t..._at_test.com> wrote:
> Hello All,
>
> Is-it possible with Enterprise Manager to know the Physical Disk Usage of a
> schema ? I've multiple schema in the user tablespace, how can i know the
> usage of my schema ?
>
> thank's..

>From the SQL*Plus command line, the following query will return the
amount of bytes used by all the objects in each of your schemas:

select owner, sum(bytes)
from dba_segments
group by owner;

HTH -g Received on Mon Jun 11 2007 - 10:04:00 CDT