Re: Schema Disk Size

On Jun 11, 10:04 am, gazzag <gar..._at_jamms.org> wrote:
> 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

select owner, sum(bytes)
from dba_segments
where tablespace_name = 'USER'
group by owner;

-or-

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

David Fitzjarrell Received on Mon Jun 11 2007 - 11:15:26 CDT